[PERFORM] Backup/Restore too slow

Hi, We have a database with one table of 10,000,000 tuples and 4 tables with 5,000,000 tuples. While in SQL Server it takes 3 minutes to restore this complete database, in PostgreSQL it takes more than 2 hours. The Backup takes 6 minutes in SQLServer and 13 minutes (which is not a problem) We ar

Re: [PERFORM] Backup/Restore too slow

Thanks for answering. This is my configuration: # - Memory - shared_buffers = 1000# min 16, at least max_connections*2, 8KB each #work_mem = 1024# min 64, size in KB #maintenance_work_mem = 16384# min 1024, size in KB #max_stack_depth = 2048# min 100, size in KB The PC

[PERFORM] Indexscan is only used if we use "limit n"

= on enable_tidscan = on Thank you. Sebastián Sebastián Baioni http://www.acomplejados.com.ar http://www.extremista.com.ar http://www.coolartists.com.ar - ¡Sé un mejor ambientalista! Encontrá consejos para cuidar el lugar donde vivimos..

[PERFORM] Inner Join of the same table

'In MS SQL Server it lasts 1minute, in PostgreSQL for Windows it lasts 40minutes and in PostgreSQL for Linux (FreeBSD) it lasts 20minuts.Do you know if there is any way to tune the server or optimize this sentence?Thanks Sebastián Baioni Sebastián Baioni Preguntá. Respondé. Des

Re: [PERFORM] Inner Join of the same table

Sort Key: t.cuiL 12-> Index Scan using uesapt002 on APORTES t (cost=0.00..122643.90 rows=62263 width=40) 13 Index Cond: (cuiT = '30701965554'::bpchar) Thanks Sebastián Baioni --- Mark Lewis <[EMAIL PROTECTED]&

Re: [PERFORM] Inner Join of the same table

ws=62263 width=40) (actual time=170.000..25566.000 rows=80471 loops=1) 13 Index Cond: (cuiT = '12345678901'::bpchar) Total runtime: 2677640.000 ms Thanks Sebastián Baioni --- "Jim C. Nasby" <[EMAIL PROTECTED]> escribió: > On Tue, Aug 15, 2

Re: [PERFORM] Inner Join of the same table

I had enable_seqscan turned OFF; With enable_seqscan turned ON it takes only 6 minutes to complete the query and not 44minuts like it did with enable_seqscan turned OFF. THANKS A LOT! It's still much more slower than MS SQL server but now it has acceptable times. Sebastián B

Re: [PERFORM] [GENERAL] Can't make backup

@Albe Wrote: > Does the dump file keep growing or not? No, it stops growing. @sanjeev We are using "..\pgAdmin III\1.6\pg_dump.exe" -i -h IPHOST -p 5432 -U user -F c -b -v -f "..\back\myfile.backup" db We are going to try the other one. @Harald, we've used pg_dump 8.3.0.7045 (From pg Admin III