FAQ

PostgreSQL > pgsql-performance > February 2013

Search Discussions

30 discussions - 202 posts

  • Hello, We upgraded from Ubuntu 11.04 to Ubuntu 12.04 and almost immediately obeserved increased CPU usage and significantly higher load average on our database server. At the time we were on Postgres ...
    Dan KoganDan Kogan
    Feb 12, 2013 at 5:26 pm
    Feb 26, 2013 at 9:46 pm
  • Server specs: Dell R610 dual E5645 hex-core 2.4GHz 192GB RAM RAID 1: 2x400GB SSD (OS + WAL logs) RAID 10: 4x400GB SSD (/var/lib/pgsql) /etc/sysctl.conf: kernel.msgmnb = 65536 kernel.msgmax = 65536 ...
    Johnny TanJohnny Tan
    Feb 5, 2013 at 10:02 pm
    Feb 12, 2013 at 2:55 am
  • (Sorry moderators for any double posts, I keep making subscription errors. Hopefully this one gets through) Hi speed freaks, Can anyone tell me why the bitmap heap scan takes so long to start for ...
    Carlo StonebanksCarlo Stonebanks
    Feb 21, 2013 at 4:57 pm
    Mar 8, 2013 at 9:28 pm
  • Hi, Since our upgrade of hardware, OS and Postgres we experience server stalls under certain conditions, during that time (up to 2 minutes) all CPUs show 100% system time. All Postgres processes show ...
    AndreAndre
    Feb 24, 2013 at 2:08 pm
    Feb 27, 2013 at 11:07 pm
  • So where I'm working, a performance issue was identified that affected many functions, because the (SQL language) functions took an int argument used it in a where clause against a column (config_id) ...
    Casey Allen ShobeCasey Allen Shobe
    Feb 1, 2013 at 5:11 pm
    Feb 1, 2013 at 10:17 pm
  • I have a planner problem that looks like a bug, but I'm not familiar enough with how planner the works to say for sure. This is my schema: create table comments ( id serial primary key, ...
    Alexander StauboAlexander Staubo
    Feb 21, 2013 at 7:44 pm
    Feb 23, 2013 at 10:10 am
  • The following query produces a Recheck Cond and a costly Bitmap Heap Scan even though I have a composite index that covers both columns being filtered and selected. I believe this is because the ...
    JackrgJackrg
    Feb 22, 2013 at 4:36 pm
    Feb 25, 2013 at 6:48 pm
  • Hello, I've been struggling to understand what's happening on my databases/query for several days, and I'm turning to higher mind for a logical answer. I'm dealing with a fairly large database, ...
    Nicolas CharlesNicolas Charles
    Feb 14, 2013 at 3:35 pm
    Feb 16, 2013 at 9:25 am
  • We upgraded from PG 9.1 to 9.2. Since the upgrade, the # of active queries has raised significantly, especially during our peak time where lots of users are logging in. According to New Relic, this ...
    Will PlatnickWill Platnick
    Feb 5, 2013 at 3:46 am
    Feb 6, 2013 at 4:28 pm
  • hello, i have a strange and reproducible bug with some select queries and 64bit postgresql builds (works fine on 32bit builds). The postgres process will run with 100% cpu-load (no io-wait) and ...
    Markus SchulzMarkus Schulz
    Feb 22, 2013 at 8:25 am
    Feb 23, 2013 at 4:14 pm
  • My postgres db ran out of space. I have 27028 files in the pg_xlog directory. I'm unclear what happened this has been running flawless for years. I do have archiving turned on and run an archive ...
    Tory M BlueTory M Blue
    Feb 14, 2013 at 10:49 am
    Feb 14, 2013 at 11:11 am
  • Hi, I have read a lot of different information about the benefits of using numerical primary key vs alphanumerical primary key(small size). And what I am gathering is that for performance there is no ...
    Anne RossetAnne Rosset
    Feb 4, 2013 at 9:52 pm
    Feb 12, 2013 at 4:26 pm
  • Hardware: IBM X3650 M3 (2 x Xeon X5680 6C 3.33GHz), 96GB RAM. IBM X3524 with RAID 10 ext4 (noatime,nodiratime,data=writeback,barrier=0) volumes for pg_xlog / data / indexes. Software: SLES 11 SP2 ...
    Mark SmithMark Smith
    Feb 21, 2013 at 9:59 am
    Mar 5, 2013 at 2:13 pm
  • Hi! I'm new to this mailinglist and I'm new to postgres as well. It is about our own backup software (java); we switched the DB from MySQL to postgres and we need some help. The backup database holds ...
    Florian SchröckFlorian Schröck
    Feb 15, 2013 at 2:31 pm
    Feb 26, 2013 at 8:01 am
  • Hi All, Hope someone can help me a little bit here: I've got a query like the following: -- select Column1, Column2, Column3 from Table1 where exists (select 1 from Table2 where Table2.ForeignKey = ...
    Bastiaan OlijBastiaan Olij
    Feb 19, 2013 at 6:35 am
    Feb 19, 2013 at 10:19 am
  • I took some time to figure out a reasonable tuning for my fresh 9.2.3 installation when I've noticed the following: [costin@fsr costin]$ /home/pgsql/bin/pgbench -h 192.1.1.2 -p 5432 -U postgres -i -s ...
    Costin OproiuCostin Oproiu
    Feb 26, 2013 at 9:45 pm
    Mar 4, 2013 at 10:46 pm
  • I am also struggling with a problem involving CTEs although in my case it is caused by huge *under*-estimation of cardinality rather then *over*-estimation. The statement is quite complex and the ...
    John LumbyJohn Lumby
    Feb 18, 2013 at 4:45 pm
    Feb 19, 2013 at 10:09 am
  • Hi, I have problems with the performance of FTS in a query like this: SELECT * FROM FullTextSearch WHERE content_tsv_gin @@ plainto_tsquery('english', 'good'); It's slow ( 30 sec.) for some GB (27886 ...
    Stefan KellerStefan Keller
    Feb 8, 2013 at 12:52 am
    Feb 8, 2013 at 5:30 pm
  • I got a problem with the performance of a PL/PGsql stored procedure outputting an xml. /Server version:/ PostgreSQL 8.3.6 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat ...
    Davide BerraDavide Berra
    Feb 22, 2013 at 9:22 am
    Mar 1, 2013 at 2:09 pm
  • Hi, Does any one can tell me why the same query runs against on smaller data is slower than bigger table. thanks very much. I am using PostgreSQL9.1.8. *t_apps_1 and t_estimate_1 are about 300M ...
    Ao JianwangAo Jianwang
    Feb 28, 2013 at 3:11 pm
    Mar 1, 2013 at 12:30 am
  • Howdy, the query generator in my app sometimes creates redundant filters of the form: project_id IN ( <list of projects user has permission to see ) AND project_id = <single project user is looking ...
    Matt DawMatt Daw
    Feb 26, 2013 at 7:35 pm
    Feb 28, 2013 at 4:31 pm
  • Hello, tweaking our connection pooler (*pgbouncer*) and *posgres 8.4 *seemed a bit confusing to us. Which key should i set for changing the limit of connection between *pgbouncer <- posgres8.4?* i ...
    Yetkin ÖztürkYetkin Öztürk
    Feb 13, 2013 at 1:48 pm
    Feb 13, 2013 at 3:35 pm
  • Hello, The Query Plan for the query below shows a large number in its actual rows count by an unknown reason. As a result Merge Join works on a large enough data to slow down the query. The table ...
    Vahe EvoyanVahe Evoyan
    Feb 21, 2013 at 7:24 am
    Feb 28, 2013 at 5:58 pm
  • Dear all, I have a problem with seqscan I hope you might help me with. Attached is the simple script that reproduces a database and results, which I have tested both on 9.0.4 and 9.3-devel with ...
    Dmitry KarasikDmitry Karasik
    Feb 27, 2013 at 10:03 am
    Feb 27, 2013 at 2:21 pm
  • I was wondering if somebody could clear up how tablespaces are used. Let's say I have three classes of storage: - ramdisk (tmpfs) - SSD - spinning rust Furthermore, let's say I'd like to be able to ...
    Jon NelsonJon Nelson
    Feb 8, 2013 at 8:53 pm
    Feb 16, 2013 at 12:32 am
  • Hi everybody! I'm new in mailing list, and i have a little question. The tables are: postalcodes (place_id, code), PK(place_id, code) 600K of rws places (id, name), PK(id), INDEX(name) 3M of rows ...
    Asmir MustaficAsmir Mustafic
    Feb 14, 2013 at 10:28 am
    Feb 14, 2013 at 11:51 am
  • This query http://pgsql.privatepaste.com/359bed8e9e gets executed every 500 ms and normally completes really quickly http://explain.depesz.com/s/poVQ, but the more job_batches table ...
    Karolis PociusKarolis Pocius
    Feb 8, 2013 at 12:37 pm
    Feb 10, 2013 at 6:52 am
  • Start off, I'm new to postgres. I'm running Ubuntu 10.04.04 with postgres 9.1 on a VM with 32 GB of RAM. I'm trying to increase the response time on submitted queries. I'm comparing the same queries ...
    Foster, Kristian B (HSC)Foster, Kristian B (HSC)
    Feb 8, 2013 at 10:14 pm
    Feb 8, 2013 at 10:46 pm
  • I'm trying to create a view that uses a window function, but it seems that Postgres is apparently unable to optimize it. Here's a reproduction of my situation with 9.2.2: --- drop table if exists ...
    Chris HanksChris Hanks
    Feb 21, 2013 at 11:37 pm
    Feb 21, 2013 at 11:37 pm
  • I managed to optimize the query below, adding a subselect (is disabled) after the "where" it would be correct? EXPLAIN (ANALYZE, BUFFERS) SELECT CONCAT_WS(' # ', CONCAT_WS(' ', produto.descricao, ...
    Alexandre RiveiraAlexandre Riveira
    Feb 11, 2013 at 12:52 pm
    Feb 11, 2013 at 12:52 pm
Feb 2013
Group Navigation
period‹ prev | Feb 2013 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions30
posts202
users72
websitepostgresql.org
irc#postgresql

72 users for February 2013

Jeff Janes: 15 posts Josh Berkus: 14 posts Scott Marlowe: 13 posts Carlo Stonebanks: 9 posts Johnny Tan: 9 posts Kevin Grittner: 8 posts Dan Kogan: 7 posts Tom Lane: 7 posts Casey Allen Shobe: 6 posts Josh Krupka: 6 posts Alexander Staubo: 4 posts Andre: 4 posts Heikki Linnakangas: 4 posts Merlin Moncure: 4 posts Pavan Deolasee: 4 posts Will Platnick: 4 posts Виктор Егоров: 4 posts Bastiaan Olij: 3 posts Florian Schröck: 3 posts Mark Kirkwood: 3 posts
show more
Archives