FAQ

PostgreSQL > pgsql-performance > October 2012

Search Discussions

50 discussions - 391 posts

  • This is driving me crazy. A new server, virtually identical to an old one, has 50% of the performance with pgbench. I've checked everything I can think of. The setups (call the servers "old" and ...
    Craig JamesCraig James
    Oct 8, 2012 at 9:45 pm
    Dec 6, 2012 at 12:53 pm
  • Hi everyone, I have a Postgresql 9.1 dedicated server with 16 cores, 96GB RAM and RAID10 15K SCSI drives which is runing Centos 6.2 x64. This server is mainly used for inserting/updating large ...
    Strahinja KustudićStrahinja Kustudić
    Oct 10, 2012 at 7:12 am
    Oct 18, 2012 at 10:06 pm
  • I have replication set up on servers with 9.1 and want to upgrade to 9.2 I was hoping I could just bring them both down, upgrade them both and bring them both up and continue replication, but that ...
    DelongboyDelongboy
    Oct 18, 2012 at 10:21 pm
    Nov 7, 2012 at 9:18 pm
  • As I increase concurrency I'm experiencing what I believe are too slow queries given the minuscule amount of data in my tables. I have 20 Django worker processes and use ab to generate 3000 requests ...
    Catalin IacobCatalin Iacob
    Oct 30, 2012 at 12:11 am
    Nov 27, 2012 at 11:17 pm
  • Hey everyone, So recently we upgraded to 9.1 and have noticed a ton of our queries got much worse. It turns out that 9.1 is *way* more optimistic about our functional indexes, even when they're ...
    Shaun ThomasShaun Thomas
    Oct 24, 2012 at 4:55 pm
    Nov 14, 2012 at 9:00 pm
  • Hi, i've got a very strange problem on PostgreSQL 8.4, where the queryplaner goes absolutely havoc, when slightly changing one parameter. First the Tables which are involved: 1. Table ...
    Böckler AndreasBöckler Andreas
    Oct 24, 2012 at 3:41 pm
    Oct 26, 2012 at 8:14 pm
  • Hey everyone! This is pretty embarrassing, but I've never seen this before. This is our system's current memory allocation from 'free -m': total used free buffers cached Mem: 72485 58473 14012 3 ...
    Shaun ThomasShaun Thomas
    Oct 22, 2012 at 5:35 pm
    Oct 29, 2012 at 4:17 pm
  • Hello! Is it possible to speed up the plan? hashes=# \d hashcheck Table "public.hashcheck" Column | Type | Modifiers ...
    KoriskKorisk
    Oct 10, 2012 at 4:09 pm
    Oct 12, 2012 at 9:28 pm
  • Hi, I have a table with about 10 millions of records, this table is update and inserted very often during the day (approx. 200 per second) , in the night the activity is a lot less, so in the first ...
    Anibal David AcostaAnibal David Acosta
    Oct 4, 2012 at 2:01 pm
    Oct 5, 2012 at 6:33 pm
  • I am configuring streaming replication with hot standby with PostgreSQL 9.1.3 on RHEL 6 (kernel 2.6.32-220.el6.x86_64). PostgreSQL was compiled from source. It works fine, except that starting the ...
    Albe LaurenzAlbe Laurenz
    Oct 29, 2012 at 1:05 pm
    Oct 30, 2012 at 1:41 pm
  • Hi all, I've created a test table containing 21 million random dates and times, but I get wildly different results when I introduce a functional index then ANALYSE again, even though it doesn't use ...
    Thom BrownThom Brown
    Oct 18, 2012 at 4:12 pm
    Oct 18, 2012 at 5:06 pm
  • I've confirmed that hyperthreading causes a huge drop in performance on a 2x4-core Intel Xeon E5620 2.40GHz system. The bottom line is: ~3200 TPS max with hyperthreading ~9000 TPS max without ...
    Craig JamesCraig James
    Oct 9, 2012 at 8:13 pm
    Oct 10, 2012 at 6:08 pm
  • Hi all, I have 10 million records in my postgres table.I am running the database in amazon ec2 medium instance. I need to access the last week data from the table. It takes huge time to process the ...
    Navaneethan RNavaneethan R
    Oct 8, 2012 at 3:26 pm
    Oct 9, 2012 at 9:49 pm
  • Hi, thanks for any help. I've tried to be thorough, but let me know if I should provide more information. A description of what you are trying to achieve and what results you expect: I have a large ...
    Woolcock, SeanWoolcock, Sean
    Oct 29, 2012 at 5:41 pm
    Oct 30, 2012 at 9:02 am
  • Dear all, We have a DB containing transactional data. There are about *50* to *100 x 10^6* rows in one *huge* table. We are using postgres 9.1.6 on linux with a *SSD card on PCIex* providing us a ...
    HoumanbHoumanb
    Oct 15, 2012 at 8:59 pm
    Oct 19, 2012 at 12:25 pm
  • We've run into a perplexing issue with a customer database. He moved from a 9.1.5 to a 9.1.6 and upgraded from an EC2 m1.medium (3.75GB RAM, 1.3 GB shmmax), to an m2.xlarge (17GB RAM, 5.7 GB shmmax), ...
    Maciek SakrejdaMaciek Sakrejda
    Oct 17, 2012 at 8:26 am
    Oct 24, 2012 at 8:39 pm
  • On PG 9.1 and 9.2 I'm running the following query: SELECT *FROM stream_store JOIN ( SELECT UNNEST(stream_store_ids) AS id FROM stream_store_version_index WHERE stream_id = 607106 AND version = 11 ) ...
    Henk de witHenk de wit
    Oct 14, 2012 at 6:55 am
    Oct 23, 2012 at 8:08 pm
  • Hello, I'm trying to do a simple SQL query over Postgresl 9.0 running on Ubuntu. I have a large table (over 100 million records) with three fields, id_signal (bigint), time_stamp (timestamp) and ...
    Pedro JiménezPedro Jiménez
    Oct 15, 2012 at 5:44 pm
    Oct 19, 2012 at 4:19 pm
  • Hi communities, I am investigating a performance issue involved with LIKE 'xxxx%' on an index in a complex query with joins. The problem boils down into this simple scenario---: ====Scenario==== My ...
    Sam WongSam Wong
    Oct 16, 2012 at 8:47 am
    Oct 18, 2012 at 7:03 am
  • Hi to all, I've got a trouble with some delete statements. My db contains a little more than 10000 tables and runs on a dedicated server (Debian 6 - bi quad - 16Gb - SAS disks raid 0). Most of the ...
    Sylvain CAILLETSylvain CAILLET
    Oct 16, 2012 at 7:50 am
    Oct 17, 2012 at 6:20 am
  • Hi! After upgrade (dump/restore/analyze) query (below) after some time is killed by kernel. Postgres creates a lot of tmp files: temporary file: path "base/pgsql_tmp/pgsql_tmp8949.2046", size 24576 ...
    Andrzej ZawadzkiAndrzej Zawadzki
    Oct 8, 2012 at 8:18 am
    Oct 8, 2012 at 4:14 pm
  • All... first let me say thank you for this forum.... I am new to it and relatively new to postgres, more of a sysadmin than a DBA, but let me explain my issue. I'll try also to post relevant ...
    RobcronRobcron
    Oct 26, 2012 at 6:30 pm
    Oct 29, 2012 at 9:40 pm
  • Hello Perf, Lately I've been pondering. As systems get more complex, it's not uncommon for tiered storage to enter the picture. Say for instance, a user has some really fast tables on a NVRAM-based ...
    Shaun ThomasShaun Thomas
    Oct 19, 2012 at 2:29 pm
    Oct 19, 2012 at 3:26 pm
  • Hi, I have pretty large tables, with columns that might never receive any data, or always receive data, based on the customer needs. The index on these columns are really big, even if the column is ...
    Franck RoutierFranck Routier
    Oct 10, 2012 at 5:06 pm
    Oct 11, 2012 at 10:31 pm
  • Hi all I have a problem with a data import procedure that involve the following query: select a,b,c,d from big_table b join data_sequences_table ds on b.key1 = ds.key1 and b.key2 = ds.key2 where ...
    Vincenzo MelandriVincenzo Melandri
    Oct 30, 2012 at 12:15 pm
    Oct 30, 2012 at 6:19 pm
  • Hello all, I have been pulling my hair out over the last few days trying to get any useful performance out of the following painfully slow query. The query is JPA created, I've just cleaned the ...
    AndyAndy
    Oct 30, 2012 at 7:34 am
    Oct 30, 2012 at 3:49 pm
  • Hi guys, PG = 9.1.5 OS = winDOS 2008R8 I have a table that currently has 207 million rows. there is a timestamp field that contains data. more data gets copied from another database into this ...
    Chris RuprechtChris Ruprecht
    Oct 16, 2012 at 11:52 pm
    Oct 17, 2012 at 12:43 am
  • I have a table with a column of type timestamp with time zone, this column has an index If I do a select like this select * from mytable where cast(my_date as timestamp without time zone) '2012-10-12 ...
    Anibal David AcostaAnibal David Acosta
    Oct 12, 2012 at 8:06 pm
    Oct 13, 2012 at 1:34 am
  • Hello, First let me say thanks for a fantastic database system. The hard work this community has put into Postgres really shows. A client of mine has been using Postgres quite effectively for a while ...
    Shane HathawayShane Hathaway
    Oct 9, 2012 at 9:43 pm
    Oct 10, 2012 at 6:38 pm
  • hi i have sql file (it's size are 1GB ) when i execute it then the String is 987098801 bytr too long for encoding conversion error occured . pls give me solution about i have XP 64-bit with 8 GB RAM ...
    Mahavir TrivediMahavir Trivedi
    Oct 30, 2012 at 9:14 am
    Nov 5, 2012 at 5:27 pm
  • Hello there, I have PostgreSQL 8.3.18 server running on Centos 6.2 (2.6.32-220.7.1) with this specs: 2x CPU AMD Opteron 6282 128GB RAM Raid 10 (12HD 15k rpm 1GB cache) with data Raid 10 (4HD 15k rpm ...
    Cesar MartinCesar Martin
    Oct 30, 2012 at 12:54 pm
    Nov 2, 2012 at 7:47 am
  • I have a problem with prepared statements choosing a bad query plan - I was hoping that 9.2 would have eradicated the problem :( Taken from the postgresql log: <2012-10-23 15:21:03 UTC acme_metastore ...
    Daniel BurbridgeDaniel Burbridge
    Oct 23, 2012 at 3:42 pm
    Oct 29, 2012 at 1:25 pm
  • Hi, I have a self-referencing table that defines a hierarchy of projects and sub-projects. This is the table definition: CREATE TABLE project ( project_id integer primary key, project_name text, ...
    Thomas KellererThomas Kellerer
    Oct 19, 2012 at 10:47 am
    Oct 19, 2012 at 5:22 pm
  • Hi, Why PostgreSQL, the EnterpriseBD supports create/alter/drop package and the opensource doesn't? Is a project or never will have support? Thanks
    Alejandro CarrilloAlejandro Carrillo
    Oct 16, 2012 at 12:26 pm
    Oct 16, 2012 at 12:53 pm
  • Hi, Given I have a large table implemented with partitions and need fast access to a (primary) key value in a scenario where every minute updates (inserts/updates/deletes) are coming in. Now since PG ...
    Stefan KellerStefan Keller
    Oct 14, 2012 at 12:43 am
    Oct 14, 2012 at 12:22 pm
  • Hi, I've been fighting with some CTE queries recently, and in the end I've ended up with two basic cases. In one case the CTEs work absolutely great, making the estimates much more precise, while in ...
    Tomas VondraTomas Vondra
    Oct 9, 2012 at 10:21 pm
    Oct 10, 2012 at 12:19 am
  • Hi, previously I selected categorized data for update then updated counts or inserted a new record if it was a new category of data. select all categories update batches of categories or insert ...
    Colin TaylorColin Taylor
    Oct 1, 2012 at 9:24 pm
    Oct 5, 2012 at 12:34 am
  • I'm struggling with a query that seems to use a suboptimal query plan. Schema: units reference a subjob reference a job. In other words: a job contains multiple subjobs. A subjob contains multiple ...
    Nick HofstedeNick Hofstede
    Oct 2, 2012 at 4:46 pm
    Oct 3, 2012 at 8:02 am
  • Hi, When i start my postgres. Iam getting this error. I had installed 8.4 and 9.1 It was working good yesterday but not now. service postgresql restart * Restarting PostgreSQL 8.4databaseserver * The ...
    VigneshVignesh
    Oct 30, 2012 at 9:24 am
    Oct 30, 2012 at 3:43 pm
  • Am I reading this correctly -- it appears that if SSL negotiation is enabled for a connection (say, when using pg_basebackup over a WAN) that compression /*is automatically used*/ (provided it is ...
    Karl DenningerKarl Denninger
    Oct 20, 2012 at 1:10 am
    Oct 21, 2012 at 7:51 am
  • Hi guys, PG = 9.1.5 OS = winDOS 2008R8 I have a table that currently has 207 million rows. there is a timestamp field that contains data. more data gets copied from another database into this ...
    Chris RuprechtChris Ruprecht
    Oct 16, 2012 at 11:46 pm
    Oct 17, 2012 at 9:08 am
  • Hello! I would like to ask following question: I have created a table and I updated all records. And I executed this update command again and again.... Execution time was growing after each step. I ...
    ViragVirag
    Oct 7, 2012 at 1:49 pm
    Oct 8, 2012 at 12:20 pm
  • Hi all, I have a question about the deadlock_timeout in regards to performance. Right now we have this timeout set at its default of 1s. My understanding of it is that this means that every 1 second ...
    Pg noobPg noob
    Oct 1, 2012 at 4:49 pm
    Oct 2, 2012 at 8:24 am
  • A followup. Recently, I imported a bunch of data. The import ran in about 30 seconds. The data itself was represented in a way that made more sense - from a relational database perspective - as ...
    Jon NelsonJon Nelson
    Oct 30, 2012 at 9:31 pm
    Oct 30, 2012 at 9:31 pm
  • Hey guys, I have a pretty nasty heads-up. If you have hardware using an Intel XEON and a newer Linux kernel, you may be experiencing very high CPU latency. You can check yourself: cat ...
    Shaun ThomasShaun Thomas
    Oct 26, 2012 at 5:59 pm
    Oct 26, 2012 at 5:59 pm
  • Hi, I have a tree-structure managed with ltree and gist index. Simplified schema is CREATE TABLE crt ( idcrt INT NOT NULL, ... pathname LTREE ) idcrt primary key and other index ix_crt_pathname on ...
    Alberto MarchesiniAlberto Marchesini
    Oct 26, 2012 at 3:30 pm
    Oct 26, 2012 at 3:30 pm
  • Hello I am working on a potentially large database table, let's call it "observation", that has a foreign key to table "measurement". Each measurement is associated with either none or around five ...
    Niko KiiralaNiko Kiirala
    Oct 17, 2012 at 1:52 pm
    Oct 17, 2012 at 1:52 pm
  • What is the adequate *pgbounce* *max_client_conn ,default_pool_size* values for a postgres config which has *max_connections = 400*. We want to move to pgbouncer to let postgres do the only db job ...
    Yetkin ÖztürkYetkin Öztürk
    Oct 17, 2012 at 7:05 am
    Oct 17, 2012 at 7:05 am
  • Hi, Our IT Company systems architecture is based on IBM Websphere Application Server, we would like to migrate our databases to Postgres, the main problem which stops us from doing that is Postgres ...
    John NashJohn Nash
    Oct 15, 2012 at 8:22 am
    Oct 15, 2012 at 8:22 am
  • I have table: create table hashcheck(id serial, name varchar, value varchar); and query: hashaggr=# explain analyse verbose select name, count(name) as cnt from hashcheck group by name order by name ...
    KoriskKorisk
    Oct 7, 2012 at 5:33 pm
    Oct 7, 2012 at 5:33 pm
Oct 2012
Group Navigation
period‹ prev | Oct 2012 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions50
posts391
users102
websitepostgresql.org
irc#postgresql

102 users for October 2012

Shaun Thomas: 32 posts Claudio Freire: 30 posts Tom Lane: 26 posts Jeff Janes: 19 posts Craig James: 15 posts Kevin Grittner: 11 posts Albe Laurenz: 10 posts Andrea Suisani: 10 posts Scott Marlowe: 10 posts Craig Ringer: 8 posts Bruce Momjian: 7 posts Korisk: 7 posts Strahinja Kustudić: 7 posts Tomas Vondra: 7 posts Böckler Andreas: 6 posts Evgeny Shishkin: 6 posts Ktm: 6 posts Sergey Konoplev: 6 posts Thom Brown: 6 posts Karl Denninger: 5 posts
show more
Archives