PgSql
in [SQL]
|
Better life <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=iso-8859-1"> </HEAD> <BODY> <table border="0" cellpadding="0" cellspacing="0" style="width: 896px"> <tr><td align="center" style="font: normal 11px Verdana, sans-serif; color: #333... 5 Jul 2010 02:25
[HACKERS] Implementation of median in PostgreSQL - questions Hello I am planning to start to implement median function. I wrote some array based implementation - it is fast, but I hope, so can be much faster. The basic question is method of implementation. It can be implemented via a) custum aggregate functions or b) executor node. Adventage of @a variant is simplici... 5 Jul 2010 02:25
[HACKERS] Always truncate segments before unlink I have a report from an user that postgres server gave up REINDEX commands on the almost-disk-full machine. The disk spaces were filled with old index segments, that should be replaced with re-constructed files made by the REINDEX. In mdunlink(), we truncate the first main fork to zero length and actually unlink... 4 Jul 2010 23:09
proof concept: do statement parametrization On Jul4, 2010, at 08:41 , Pavel Stehule wrote: I enhanced DO statement syntax to allowing a parameters. Syntax is relative simple: do ([varname] vartype := value, ...) $$ ... $$ I think it'd be more useful to put the values at the very end of the statement, not somewhere in the middle. For positional ... 4 Jul 2010 19:54
[HACKERS] proof concept: do statement parametrization Hello I enhanced DO statement syntax to allowing a parameters. Syntax is relative simple: do ([varname] vartype := value, ...) $$ ... $$ It allows to pass a content of psql variables to inline code block to allows more easy scripting \set schema 'public' do(text := :'schema') $$ declare r record; beg... 4 Jul 2010 03:39
pessimal trivial-update performance Robert Haas <robertmhaas(a)gmail.com> writes: CREATE OR REPLACE FUNCTION update_tab() RETURNS void AS $$ BEGIN INSERT INTO tab VALUES (0); FOR i IN 1..100000 LOOP UPDATE tab SET x = x + 1; END LOOP; END $$ LANGUAGE plpgsql; I believe that none of the dead row versions can be vacuumed durin... 5 Jul 2010 18:52
[HACKERS] test_fsync output improvement I have modified src/tools/test_fsync so its output is operations per second, instead of total seconds, e.g.: Loops = 10000 Simple write: 8k write 52549.436/second Compare file sync methods using one write: (open_datasync unavailable) open_sync 8k write ... 3 Jul 2010 23:20
Why is vacuum_defer_cleanup_age PGC_USERSET? On Sat, 2010-07-03 at 13:07 -0400, Tom Lane wrote: It seems to me it ought to be PGC_SIGHUP. In the first place, the actually important value under normal circumstances is going to be that seen by autovac workers. There is also some impact on HOT cleanup, but I can't see any sane argument why you don't wa... 7 Jul 2010 17:53
[HACKERS] Why is vacuum_defer_cleanup_age PGC_USERSET? It seems to me it ought to be PGC_SIGHUP. In the first place, the actually important value under normal circumstances is going to be that seen by autovac workers. There is also some impact on HOT cleanup, but I can't see any sane argument why you don't want all backends to be applying the same value for that, sin... 3 Jul 2010 13:28
reassign owned to change the ownership for op class and family On Thu, Jul 1, 2010 at 11:19 AM, Asko Tiidumaa <asko.tiidumaa(a)gmail.com> wrote: Currently REASSIGN OWNED complains "unexpected classid" for operator class and family. For example, create two users, user1 and user2 under user1: create type oxetype as enum ('oxe1'); create operator class oxe... 3 Jul 2010 12:22 |