Re: [GENERAL] out-of-line (TOAST) storage ineffective when loading from dump?

2008/2/19, Richard Huxton <[EMAIL PROTECTED]>: > Markus Bertheau wrote: > > 2008/2/19, Richard Huxton <[EMAIL PROTECTED]>: > > I'm loading a table with some short attributes and a large toastable > > attribute. > > That means that for every main table h

Re: [GENERAL] out-of-line (TOAST) storage ineffective when loading from dump?

2008/2/19, Richard Huxton <[EMAIL PROTECTED]>: > Markus Bertheau wrote: > > Afaics, TOAST was invented so that big attributes wouldn't be in the > > way when working with the other attributes. > > Actually, I think it was designed as a way of working around PG&#x

[GENERAL] out-of-line (TOAST) storage ineffective when loading from dump?

;t got any numbers to back this theory up. What do you think? Markus Bertheau ---(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

[GENERAL] Lockless pg_buffercache

Hi, I want to use the pg_buffercache contrib module for monitoring our server. It takes a lock on all buffers and then on each buffer header in order to get a consistent picture of the buffers. I would be running the function provided by the module once every 5 minutes. I'm worrying about the per

Re: [GENERAL] [ANNOUNCE] CRITICAL RELEASE: Minor Releases to Fix DoS

eindex his text column indexes or not? Markus Bertheau ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] performance of IN (subquery)

On Fri, 27 Aug 2004 11:09:26 -0400, Joseph Shraibman <[EMAIL PROTECTED]> wrote: > How does EXECUTE solve the cached-plan business? It re-plans the query at every run. -- Markus Bertheau <[EMAIL PROTECTED]> ---(end of broadcast)-

Re: [GENERAL] Alter field type?

table to set the new column to the old > value. then drop the old column. Then you might want to vacuum full the table. Does vacuum full completely remove the dropped column? Thanks -- Markus Bertheau <[EMAIL PROTECTED]> ---(end of broadcast)-

[GENERAL] PostgreSQL 7.4.2 allows foreign key violation

ders my theory invalid. Can someone comment? I also tried the same rule without INSTEAD. That does what I want and it is what I'm using in the application now. I wonder if that is The Right WayÂ. And should PostgreSQL allow foreign key violations like in the example above? Thanks -- Markus B

[GENERAL] Information about the type of elements in an array from libpq

Ð ÐÐÐ, 02.08.2004, Ð 14:49, Federico Di Gregorio ÐÐÑÐÑ: > On lun, 2004-08-02 at 14:30 +0200, Markus Bertheau wrote: > > Hi, > > > > I wonder if there is some kind of support for PostgreSQL's arrays in > > psycopg? The fetch routines return the literal array syntax

[GENERAL] order of statements in create function

a special reason to this? I have a hard time believing that everyone does it the same way by coincidence. Thanks. -- Markus Bertheau <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] pivot table sql -- COUNT() not working as expected

07' AND '2004-03-14' THEN 42 ELSE NULL END) AS "Total 03/07/04" or COUNT(CASE WHEN p.added_on BETWEEN '2004-03-07' AND '2004-03-14' THEN true ELSE NULL END) AS "Total 03/07/04" which is all the same. -- Markus Bertheau <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [GENERAL] Firebird vrs Postgresql

of a database name in PostgreSQL is a filename on the servers file system. Other that that it's a serious database. -- Markus Bertheau. Berlin, Berlin. Germany. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Redhat's "enhancements" to PG

В Сбт, 28.06.2003, в 06:36, Tom Lane пишет: > regards, tom lane > Red Hat Database project Heh, it's now "PostgreSQL - Red Hat Edition Project" :) -- Markus Bertheau. Berlin, Berlin. Germany. ---