Re: [HACKERS] Lazy constraints / defaults

2008-03-10 Thread Michał Zaborowski
keeps all information in pg_class, pg_attribute everyone can get how the changes ware made. -- Regards, Michał Zaborowski (TeXXaS) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] Lazy constraints / defaults

2008-03-09 Thread Michał Zaborowski
, then DEFAULT, then UPDATE on all rows in chunks, then NOT NULL... Can it be little simpler? -- Regards, Michał Zaborowski (TeXXaS) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] constraint with no check

2008-03-08 Thread Michał Zaborowski
in troubles. Also explicit lock release can help with bulk updates. You see - maybe it is not a problem - but doing all that some how silly job - day by day... is boring. Hope it can help. -- Regards, Michał Zaborowski (TeXXaS) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] Sorting Improvements for 8.4

2007-12-19 Thread Michał Zaborowski
works nice. -- Regards, Michał Zaborowski (TeXXaS) ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] VLDB Features

2007-12-18 Thread Michał Zaborowski
be much faster that single-thread load - surprisingly - at least for me. -- Regards, Michał Zaborowski (TeXXaS) ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your