FAQ

PostgreSQL > pgsql-performance > December 2010

Search Discussions

35 discussions - 342 posts

  • We are in the process of deciding on how to proceed on a database upgrade. We currently have MS SQL 2000 running on Windows 2003 (on my test server). I was shocked at the cost for MS SQL 2008 R2 for ...
    Tom PolakTom Polak
    Dec 7, 2010 at 6:03 pm
    Dec 18, 2010 at 3:53 pm
  • I need to build a new high performance server to replace our current production database server. The current server is a SuperMicro 1U with 2 RAID-1 containers (one for data, one for log, SAS - data ...
    Benjamin KrajmalnikBenjamin Krajmalnik
    Dec 8, 2010 at 11:16 pm
    Dec 14, 2010 at 3:31 am
  • I have server computer install Windows 2008R2, PostgreSQL 9.0.1 64 bit, 8G RAM, RAID 10 - 4 disks, dedicated server Here is config of postgresql.conf after running pgtune default_statistics_target = ...
    TuanhoanganhTuanhoanganh
    Dec 18, 2010 at 6:15 pm
    Dec 23, 2010 at 4:38 pm
  • Hi all, I notice that when restoring a DB on a laptop with an SDD, typically postgres is maxing out a CPU - even during a COPY. I wonder, what is postgres usually doing with the CPU? I would have ...
    Royce AusburnRoyce Ausburn
    Dec 13, 2010 at 2:50 am
    Jan 5, 2011 at 6:49 am
  • Hi everyone, I've been trialling different inheritance schemes for partitioning to a large number of tables. I am looking at ~1e9 records, totaling ~200GB. I've found that a k-ary table inheritance ...
    John PapandriopoulosJohn Papandriopoulos
    Dec 3, 2010 at 9:53 pm
    Dec 6, 2010 at 9:54 pm
  • I have a table "aaa" which is not very big. It has less than 10'000 rows. However read operations on this table is very frequent. Whenever I try to create a new table "bbb" with foreign key pointing ...
    KakarukeysKakarukeys
    Dec 28, 2010 at 7:24 am
    Jan 13, 2011 at 3:55 pm
  • Dear Friends, I have a requirement for running more that 15000 queries per second. Can you please tell what all are the postgres parameters needs to be changed to achieve this. Already I have 17GB ...
    Selvi88Selvi88
    Dec 16, 2010 at 12:33 pm
    Jan 6, 2011 at 9:42 pm
  • When testing the IO performance of ioSAN storage device from FusionIO (650GB MLC version) one of the things I tried is a set of IO intensive operations in Postgres: bulk data loads, updates, and ...
    Przemek WozniakPrzemek Wozniak
    Dec 23, 2010 at 6:05 pm
    Jan 4, 2011 at 1:53 pm
  • Can you help me understand how to optimize the following. There's a subplan which in this case returns 3 rows, but it is really expensive: ...
    Bryce NesbittBryce Nesbitt
    Dec 8, 2010 at 6:54 pm
    Jan 18, 2011 at 9:42 pm
  • Hi, Just stumbled on the following post: http://yoshinorimatsunobu.blogspot.com/2010/10/using-mysql-as-nosql-story-for.html The post claim that MySQL can do more qps then MemCahed or any other NoSQL ...
    Michael Ben-NesMichael Ben-Nes
    Dec 21, 2010 at 9:16 am
    Jan 9, 2011 at 1:58 pm
  • I wrote a test program in C++ using libpq. It works as follows (pseudo code): for ( int loop = 0; loop < 1000; ++loop ) { PQexec("BEGIN"); const char* sql = "INSERT INTO pg_perf_test (id, text) ...
    Werner ScholtesWerner Scholtes
    Dec 15, 2010 at 3:08 pm
    Dec 16, 2010 at 3:09 pm
  • Manual: http://www.postgresql.org/docs/9.0/static/runtime-config-wal.html#RUNTIME-CONFIG-WAL-SETTINGS Recent discussion: ...
    Rob WultschRob Wultsch
    Dec 5, 2010 at 8:40 pm
    Dec 8, 2010 at 7:01 pm
  • Hi I have the problem that on our servers it happens regularly under a certain workload (several times per minute) that all backend processes get a SIGUSR1 and spend several seconds in ...
    Julian v. BockJulian v. Bock
    Dec 29, 2010 at 2:59 pm
    Dec 30, 2010 at 3:04 pm
  • Hi all, I have a table that in the typical case holds two minute sample data for a few thousand sources. Often we need to report on these data for a particular source over a particular time period ...
    Royce AusburnRoyce Ausburn
    Dec 16, 2010 at 11:49 pm
    Dec 19, 2010 at 3:07 am
  • How can you tell when your indexes are starting to get bloated and when you need to rebuild them. I haven't seen a quick way to tell and not sure if it's being tracked. This communication is for ...
    John W StrangeJohn W Strange
    Dec 14, 2010 at 2:48 pm
    Dec 18, 2010 at 3:56 am
  • Hi, all. I'm trying to query table: EXPLAIN SELECT "v"."id", "v"."title" FROM "video" AS "v" WHERE (v.active) (v.fts @@ 'dexter:A|season:A|seri:A|декстер:A|качество:A|сезон:A|серия:A'::tsquery and ...
    Rauan MaemirovRauan Maemirov
    Dec 15, 2010 at 2:01 pm
    Dec 1, 2011 at 6:12 am
  • hello. I ve the table NumeryA with 3 indices. Query below uses incorrect index. SELECT A."NKA", A."NTA", Min("PołączeniaMin") || ',' || Max("PołączeniaMax") AS "Biling", Sum("Ile")::text AS "Ilość ...
    Pasman PasmańskiPasman Pasmański
    Dec 21, 2010 at 2:33 pm
    Dec 22, 2010 at 4:01 pm
  • Is there a way force the db to re-evaluate its execution plan for a FK without bouncing the DB? PostgreSQL 8.1.17 In our latest release our developers have implemented some new foreign keys but ...
    Eric ComeauEric Comeau
    Dec 16, 2010 at 12:24 pm
    Dec 17, 2010 at 6:54 am
  • Is there any performance penalty when I use ODBC library vs using libpq? Best Regards, Divakar
    Divakar SinghDivakar Singh
    Dec 9, 2010 at 4:31 am
    Dec 10, 2010 at 2:32 am
  • Hi ALL: My Database is for logs only, I almost have 30G data growth in my database. I Use partition table to store those data, those tables are partitioned by time column daily. My data only keep for ...
    Marc.hsiaoMarc.hsiao
    Dec 28, 2010 at 5:59 am
    Jan 12, 2011 at 8:21 am
  • hello -- i have a schema similar to the following create table foo ( id integer not null, val integer not null, s integer not null, e integer not null ); create index foo_s_idx on foo using btree ...
    BenBen
    Dec 23, 2010 at 8:07 pm
    Jan 2, 2011 at 9:56 pm
  • I have encountered a problem while restoring the database. There is a table that contains XML data (BLOB), ~ 3 000 000 records, ~ 5.5Gb of data. pg_restore has been running for a week without any ...
    Vlad ArkhipovVlad Arkhipov
    Dec 7, 2010 at 9:00 am
    Dec 9, 2010 at 5:29 am
  • I was asked about performance of PostgreSQL on NetApp, the protocol should be NFSv3. Has anybody tried it? The database in question is a DW type, a bunch of documents indexed by Sphinx. Does anyone ...
    Mladen GogalaMladen Gogala
    Dec 21, 2010 at 7:29 pm
    Jan 12, 2011 at 1:43 am
  • Hi, I have a performance trouble with UNION query First I have this view : SELECT a,b,c FROM table1, table2 WHERE jointure AND condition Result : 150 000 records in 1~2 s Then, I adding an UNION into ...
    Olivier PalaOlivier Pala
    Dec 9, 2010 at 11:02 am
    Dec 20, 2010 at 6:57 pm
  • Hi all, I have a table that stores all the page loads in my web application: shs-dev=# \d log_event Table "public.log_event" Column | Type | Modifiers ...
    Mathieu De ZutterMathieu De Zutter
    Dec 4, 2010 at 11:57 am
    Dec 4, 2010 at 3:32 pm
  • In Oracle, deferrable primary keys are enforced by non-unique indexes. That seems logical, because index should tolerate duplicate values for the duration of transaction: Connected to: Oracle ...
    Mladen GogalaMladen Gogala
    Dec 1, 2010 at 4:46 pm
    Dec 1, 2010 at 5:13 pm
  • How good are certmagic.com practice exams for PostgreSQL exam? My friends told me they are pretty good and he has passed many exams with their material. Let me know guys!
    nextage Technextage Tech
    Dec 30, 2010 at 7:54 am
    Jan 4, 2011 at 2:07 pm
  • hello. i tested how are distributed values xmin,xmax on pages. in my tables . typically there are no more than 80 records on pages. maybe its possible to compress xmin & xmax values to 1 byte/per ...
    Pasman PasmańskiPasman Pasmański
    Dec 6, 2010 at 2:41 pm
    Dec 19, 2010 at 6:22 pm
  • Pessoal, Estou com uma dúvida ao fazer Tunning no arquivo de configuração do Postgres. Minha aplicação tem varios acessos simultâneos, chegando picos de 2000 mil ou até mais. Por ser uma aplicação ...
    SalimaSalima
    Dec 8, 2010 at 5:12 pm
    Dec 14, 2010 at 7:30 am
  • Hello, Is is possible to create an index on a field on a function that returns a data type that contains subfields? It is possible to do this: create index indx_test on address ...
    Desmond CoertzenDesmond Coertzen
    Dec 23, 2010 at 4:53 pm
    Dec 23, 2010 at 5:03 pm
  • I have a table in Postgresql 9.0.1 as folllows: Table "public.crmentity" Column | Type | Modifiers --------------+-----------------------------+-------------------- crmid | integer | not null ...
    AI RummanAI Rumman
    Dec 15, 2010 at 6:56 am
    Dec 15, 2010 at 8:59 am
  • Hello Postgres Users. Last days I've installed and configured new x64 release of PostgreSQL running Windows 2008 R2 with dual XEON 5530 processors (2x4xHT = 16 working units). Previously the database ...
    Piotr CzekalskiPiotr Czekalski
    Dec 2, 2010 at 9:04 pm
    Dec 3, 2010 at 7:22 am
  • Hello, Is is possible to create an index on a field on a function that returns a data type that contains subfields? It is possible to do this: create index indx_test on address ...
    Desmond CoertzenDesmond Coertzen
    Dec 23, 2010 at 4:34 pm
    Dec 23, 2010 at 4:34 pm
  • I've developed PostBIX, a multithread daemon to monitor Postgres SQL fully integrated with zabbix, released under GPL V.3, and written in java. I hope people can find this post useful everyone can ...
    Andrea Dalle VaccheAndrea Dalle Vacche
    Dec 3, 2010 at 1:48 pm
    Dec 3, 2010 at 1:48 pm
  • Thanks for explanation. -- ------------ pasman
    Pasman PasmańskiPasman Pasmański
    Dec 1, 2010 at 11:38 am
    Dec 1, 2010 at 11:38 am
Dec 2010
Group Navigation
period‹ prev | Dec 2010 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions35
posts342
users98
websitepostgresql.org
irc#postgresql

98 users for December 2010

Tom Lane: 21 posts Mladen Gogala: 18 posts Kevin Grittner: 17 posts Robert Haas: 17 posts Pierre C: 14 posts Scott Marlowe: 13 posts Tuanhoanganh: 9 posts John Papandriopoulos: 8 posts Marti Raudsepp: 8 posts Andy Colson: 7 posts Greg Smith: 7 posts Alaricd: 6 posts Divakar Singh: 6 posts Jignesh Shah: 6 posts Mario Splivalo: 6 posts Pasman Pasmański: 6 posts Andy: 5 posts Bruce Momjian: 5 posts Craig James: 5 posts Jeff Janes: 5 posts
show more
Archives