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's 8KB block-size. That imposed a maximum row

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 heap page several toast table heap pages are written

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

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

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

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)--- TIP 7: don't

[GENERAL] PostgreSQL 7.4.2 allows foreign key violation

like in the example above? Thanks -- Markus Bertheau [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

[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 of PostgreSQL. I'd want the fetch routines

[GENERAL] order of statements in create function

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

. -- 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

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