Re: [PERFORM] Determine dead tuples size

Hello, Michael. > On Thu, Mar 15, 2007 at 01:58:47PM +0600, Alexey Romanchuk wrote: >> is it possible to determine dead tuples size for table? > See contrib/pgstattuple. thanks, i install contribs and try to analyze result of pgstattuple function and found it strange. Here it is output:

Re: [PERFORM] Postgres batch write very slow - what to do

femski <[EMAIL PROTECTED]> writes: > If 17k record/sec is right around expected then I must say I am little > disappointed from the "most advanced open source database". Well, the software is certainly capable of much more than that; for instance, on a not-too-new Dell x86_64 machine: regression=

Re: [PERFORM] Dispatch-Merge pattern

On Mar 13, 2007, at 6:36 AM, James Riordan wrote: Howdy- I am currently using PostgreSQL to store and process a high-bandwidth event stream. I do not need old events but the delete and vacuum does not terminate due to the large number of events being inserted (it just pushes me over the tippi

[PERFORM] Dispatch-Merge pattern

Howdy- I am currently using PostgreSQL to store and process a high-bandwidth event stream. I do not need old events but the delete and vacuum does not terminate due to the large number of events being inserted (it just pushes me over the tipping point of where the machine can keep up with the ev

Re: [PERFORM] Postgres batch write very slow - what to do

I tried maxpages = 0 and full_page_writes=off and it seemed to be taking forever. All other tricks I have already tried. At this point I wondering if its a jdbc client side issue - I am using the latest 8.1. (as I said in an earlier post - I am using addBatch with batch size of 100). But just in

Re: [PERFORM] Determine dead tuples size

On Thu, Mar 15, 2007 at 01:58:47PM +0600, Alexey Romanchuk wrote: > is it possible to determine dead tuples size for table? See contrib/pgstattuple. -- Michael Fuhr ---(end of broadcast)--- TIP 5: don't forget to increase your free space map setti

Re: [PERFORM] Determine dead tuples size

Try the contrib module pgstattuple. 2007/3/15, Alexey Romanchuk <[EMAIL PROTECTED]>: Hello guys, is it possible to determine dead tuples size for table? -- Alexey Romanchuk ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, ple

[PERFORM] unsubscribe

unsubscribe

[PERFORM] Determine dead tuples size

Hello guys, is it possible to determine dead tuples size for table? -- Alexey Romanchuk ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that yo