Re: [PERFORM] Why is restored database faster?

directory takes on each machine. What directory is of interest? The whole thing takes up about 875 MB on each machine. -David ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[PERFORM] Why is VACUUM ANALYZE table so slow?

. -David ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [PERFORM] Measuring execution time for sql called from PL/pgSQL

. -David ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [PERFORM] Why is VACUUM ANALYZE table so slow?

PostgreSQL. -David On Tuesday, December 16, 2003 2:51 PM, Neil Conway [SMTP:[EMAIL PROTECTED] wrote: David Shadovitz [EMAIL PROTECTED] writes: I'm running PG 7.2.2 on RH Linux 8.0. Note that this version of PostgreSQL is quite old. I'd like to know why VACUUM ANALYZE table is extemely slow (hours

[PERFORM] Why is restored database faster?

for this difference? Clustering? How can I get the original server to perform as well as the new one? Thanks. -David ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[PERFORM] Query plan - now what?

Well, now that I have the plan for my slow-running query, what do I do? Where should I focus my attention? Thanks. -David Hash Join (cost=16620.59..22331.88 rows=40133 width=266) (actual time=118773.28..580889.01 rows=57076 loops=1) - Hash Join (cost=16619.49..21628.48 rows=40133

Re: [PERFORM] Query plan - now what?

suggestions on statistics_target and enable_hash_join. Thanks. -David ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [PERFORM] Another weird one with an UPDATE

on commercial_entity ce (cost=0.00..4787.69 rows=78834 width=24) (actual time=0.02..55.64 rows=7991 loops=1) Total runtime: 226239.77 msec (10 rows) David - Original Message - From: Stephan Szabo [EMAIL PROTECTED] To: David Griffiths [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, October 12

Re: [PERFORM] Another weird one with an UPDATE

runtime: 239585.09 msec (9 rows) Anyone have any thoughts? David ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [PERFORM] Another weird one with an UPDATE

Thanks - that worked. David - Original Message - From: Stephan Szabo [EMAIL PROTECTED] To: David Griffiths [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, October 11, 2003 3:34 PM Subject: Re: [PERFORM] Another weird one with an UPDATE On Sat, 11 Oct 2003, David Griffiths wrote

Re: [PERFORM] Index/Foreign Key Question

- Original Message - From: Ron Johnson On Fri, 2003-10-10 at 16:04, David Busby wrote: List, I'm creating this multi company POS database. My inventory table looks like (all items are unique): id,category_id,invoice_id,x,y,z,gid,uid I have a primary key on id

[PERFORM] Index/Foreign Key Question

? Or since I have the FK setup are the indexes already in place? I expect to soon have 500K items in the inventory table and don't want it to slow down. I'll have the same type of issue with clients, invoices, purchase_orders and perhaps more Ideas? Thanks! David Busby Systems Engineer

Re: [PERFORM] PostgreSQL vs MySQL

you find out about it, that salesperson has most likely lost a customer. Anyway, I hope I haven't offended anyone - I'm not trying to troll or flame, but rather just give some constructive criticism from someone outside both the MySQL and Postgres camps. David

[PERFORM] Tuning/performance issue...

untry.country_id)Total runtime: 42165.44 msec(21 rows) I will post the schema in a seperate email - the list has rejected one big email 3 times now. David

[PERFORM] Tuning/performance issue (part 2)

query to see if I could at least figure out where the time was being spent. Part 3 to follow. David

Re: [PERFORM] Tuning/performance issue...

. The developers know SQL, but nothing about tuning, etc. Thanks for the quick response - I will try explicit joining, and I'm looking forward to your comments on outer-joins and the optmizer (and anything else I've written). David. ---(end of broadcast

[PERFORM] Test...

I've posted several emails, and have yet to see one show up (this one might not either). Is there a size limit to an email (it had a big analyze, and schema information)?? David

<    5   6   7   8   9   10