Re: [GENERAL] Space for pg_dump

On Tue, 31 Mar 2009, Scott Marlowe wrote: Sadly, there is no exact maths for such things. If your database has tons of indexes and such, it might be 20 or 100 times bigger on disk than it will be during backup. If it's all compressible text with few indexes, it might be a 1:1 or so size. Sin

Re: [GENERAL] Space for pg_dump

Greg Smith wrote: >On Tue, 31 Mar 2009, Scott Marlowe wrote: > >> Sadly, there is no exact maths for such things. If your database has >> tons of indexes and such, it might be 20 or 100 times bigger on disk >> than it will be during backup. If it's all compressible text with few >> indexes, it m

[GENERAL] Community account

Hello, I signed up a couple of months ago but never received the confirmation email. If I try to create a new account with the same email address, but a different handle it is denied with this error message: "A user with that email already exists". When I click on the 'lost password' link and en

Re: [GENERAL] number of relations reported by vacuumdb -av

never mindI found the answer in the archives.postgresql.org. The answer is 'yes' I use the sum of relations from all of the databases. So I have reset 'max_fsm_relations' from 1000 to 2000. Irene Barg wrote: Hi, I have a PostgreSQL installation with 8 databases (counting postgres, templa

Re: [GENERAL] Full text search strategy for names

On Apr 17, 2009, at 7:02 AM, Rick Schumeyer wrote: You can get extra (undesirable) results, depending on the name. For example, if you are searching for the last name of "Ricks", you will also find all authors whose first name is "Rick" If you can process the names separately from the res

Re: [GENERAL] Community account

On Sat, Apr 18, 2009 at 3:49 AM, Rainer Bauer wrote: > Hello, > > I signed up a couple of months ago but never received the confirmation email. > > If I try to create a new account with the same email address, but a different > handle it is denied with this error message: "A user with that email a

Re: [GENERAL] number of relations reported by vacuumdb -av

Good Morning Irene could you verify the requirement to set max_fsm_pages (integer) to 16 times new value of 'max_fsm_relations' Thanks! Martin Gainty __ Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung / Note de déni et de confid

Re: [GENERAL] Community account

Hello Scott, Saturday, April 18, 2009, 4:21:29 PM, you wrote: SM> On Sat, Apr 18, 2009 at 3:49 AM, Rainer Bauer wrote: >> Hello, >> >> I signed up a couple of months ago but never received the confirmation email. >> >> If I try to create a new account with the same email address, but a different

Re: [GENERAL] Community account

On Sat, Apr 18, 2009 at 8:27 AM, Rainer Bauer wrote: > Hello Scott, > > Saturday, April 18, 2009, 4:21:29 PM, you wrote: > > SM> On Sat, Apr 18, 2009 at 3:49 AM, Rainer Bauer wrote: >>> Hello, >>> >>> I signed up a couple of months ago but never received the confirmation >>> email. >>> >>> If I

Re: [GENERAL] Space for pg_dump

Rainer Bauer writes: > Greg Smith wrote: >> Since running an entire pgdump can take forever on a big database, what I >> usually do here is start by running the disk usage query at >> http://wiki.postgresql.org/wiki/Disk_Usage > Interesting. However, the query gives an error if the table name c

[GENERAL] Nooby Q: Should this take five hours? And counting?

ie, 5hrs and counting, no clue how long it intends to run, but methinks this is insane even if it is 10^7 records, mebbe half a dozen dups per value (a product-id usually around 8-chars long): CREATE INDEX web_source_items_by_item_id_strip ON web_source_items USING

Re: [GENERAL] Nooby Q: Should this take five hours? And counting?

On Sat, Apr 18, 2009 at 4:11 PM, Kenneth Tilton wrote: > ie, 5hrs and counting, no clue how long it intends to run, but methinks this > is insane even if it is 10^7 records, mebbe half a dozen dups per value (a > product-id usually around 8-chars long): > > CREATE INDEX web_source_items_by_item_id

Re: [GENERAL] Nooby Q: Should this take five hours? And counting?

Scott Marlowe wrote: > On Sat, Apr 18, 2009 at 4:11 PM, Kenneth Tilton wrote: >> ie, 5hrs and counting, no clue how long it intends to run, but methinks this >> is insane even if it is 10^7 records, mebbe half a dozen dups per value (a >> product-id usually around 8-chars long): >> >> CREAT

Re: [GENERAL] Nooby Q: Should this take five hours? And counting?

On Sat, Apr 18, 2009 at 6:32 PM, Kenneth Tilton wrote: > > > Scott Marlowe wrote: >> On Sat, Apr 18, 2009 at 4:11 PM, Kenneth Tilton >> wrote: >>> ie, 5hrs and counting, no clue how long it intends to run, but methinks >>> this >>> is insane even if it is 10^7 records, mebbe half a dozen dups per

Re: [GENERAL] Nooby Q: Should this take five hours? And counting?

MG>take a look at the man page for vmstat Martin Gainty __ Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung / Note de déni et de confidentialité This message is confidential. If you should not be the intended receiver, then we a

Re: [GENERAL] Nooby Q: Should this take five hours? And counting?

Scott Marlowe wrote: On Sat, Apr 18, 2009 at 6:32 PM, Kenneth Tilton wrote: Scott Marlowe wrote: On Sat, Apr 18, 2009 at 4:11 PM, Kenneth Tilton wrote: ie, 5hrs and counting, no clue how long it intends to run, but methinks this is insane even if it is 10^7 records, mebbe half a dozen dup

Re: [GENERAL] Nooby Q: Should this take five hours? And counting?

On Sat, Apr 18, 2009 at 6:32 PM, Kenneth Tilton wrote: > > > Scott Marlowe wrote: >> On Sat, Apr 18, 2009 at 4:11 PM, Kenneth Tilton >> wrote: >>> ie, 5hrs and counting, no clue how long it intends to run, but methinks >>> this >>> is insane even if it is 10^7 records, mebbe half a dozen dups per