FAQ

Search Discussions

48 discussions - 450 posts

  • Hi Guys, I'm just doing some tests on a new server running one of our heavy select functions (the select part of a plpgsql function to allocate seats) concurrently. We do use connection pooling and ...
    Glyn AstillGlyn Astill
    Apr 11, 2011 at 6:04 pm
    Apr 15, 2011 at 6:58 am
  • I have been wrestling with the configuration of the dedicated Postges 9.0.3 server at work and granted, there's more activity on the production server, but the same queries take twice as long on the ...
    OgdenOgden
    Apr 12, 2011 at 4:36 pm
    Apr 29, 2011 at 11:02 pm
  • Hi, I am using PostgreSQL 9.0. There is a salutations table with 44 rows, and a contacts table with more than a million rows. The contacts table has a nullable (only 0.002% null) salutation_id ...
    Sok Ann YapSok Ann Yap
    Apr 26, 2011 at 9:49 am
    May 24, 2011 at 9:12 am
  • Is there anyone that could help me understand why all of a sudden with no noticeable change in data, no change in hardware, no change in OS, I'm seeing postmaster getting killed by oom_killer? The ...
    Tory M BlueTory M Blue
    Apr 21, 2011 at 8:28 am
    Apr 24, 2011 at 4:22 am
  • Dear all, I have a Postgres database server with 16GB RAM. Our application runs by making connections to Postgres Server from different servers and selecting data from one table & insert into ...
    Adarsh SharmaAdarsh Sharma
    Apr 4, 2011 at 9:40 am
    Apr 5, 2011 at 1:50 pm
  • Hello, I saw some recommendations from people on the net not to use background fsck when running PostgreSQL on FreeBSD. As I recall, these opinions were just thoughts of people which they shared with ...
    Ireneusz PlutaIreneusz Pluta
    Apr 6, 2011 at 10:40 pm
    Apr 18, 2011 at 9:49 pm
  • Would really appreciate someone taking a look at the query below.... Thanks in advance! this is on a linux box... Linux dsrvr201.larc.nasa.gov 2.6.18-164.9.1.el5 #1 SMP Wed Dec 9 03:27:37 EST 2009 ...
    Maria L. WilsonMaria L. Wilson
    Apr 5, 2011 at 7:26 pm
    May 11, 2011 at 2:31 pm
  • I have a stored proc that potentially inserts hundreds of thousands, potentially millions, of rows (below). This stored proc is part of the the sequence of creating an ad campaign and links an ad to ...
    Joel ReymontJoel Reymont
    Apr 30, 2011 at 4:57 pm
    May 1, 2011 at 11:30 pm
  • Hi, Anyone lucky to have dbt5 run for PostgreSQL 9.0.3?! I am trying on Novell SuSE Linux Enterprise Server 11 SP1 x86_64 with a virtual machine and bit hard with no success run yet. If you can help ...
    Sethu PrasadSethu Prasad
    Apr 12, 2011 at 7:51 am
    Sep 24, 2011 at 3:46 pm
  • 2 kingston V+100 500GB Soft RAID1 (md) ioscheduler [noop] ext3 Linux pro-cdn1 2.6.26-2-amd64 #1 SMP Tue Jan 25 05:59:43 UTC 2011 x86_64 GNU/Linux Filesystem Size Used Avail Use% Mounted on /dev/md4 ...
    Laurent LabordeLaurent Laborde
    Apr 19, 2011 at 9:15 am
    Apr 22, 2011 at 9:53 pm
  • Hi, Had a recent conversation with a tech from this company called FUSION-IO. They sell io cards designed to replace conventional disks. The cards can be up to 3 TB in size and apparently are ...
    Mark StebenMark Steben
    Apr 29, 2011 at 2:24 pm
    Apr 29, 2011 at 7:15 pm
  • Not sure if this is the right list...but: Disclaimer: I realize this is comparing apples to oranges. I'm not trying to start a database flame-war. I just want to say thanks to the PostgreSQL ...
    J SissonJ Sisson
    Apr 25, 2011 at 7:31 pm
    Apr 26, 2011 at 5:57 pm
  • All, Apparently our CE is unable to deal with even moderately complex expressions. For example, given a CE check constraint of: "chk_start" CHECK (start = '2011-01-31 00:00:00-05'::timestamp with ...
    Josh BerkusJosh Berkus
    Apr 20, 2011 at 11:49 pm
    Apr 21, 2011 at 5:36 pm
  • I have a table that I need to rebuild indexes on from time to time (records get loaded before indexes get build). To build the indexes, I use 'create index ...', which reads the entire table and ...
    Chris RuprechtChris Ruprecht
    Apr 9, 2011 at 4:55 pm
    Apr 11, 2011 at 6:50 pm
  • I'm using 9.1dev. Could someone explain the following behaviour? -- create a test table CREATE TABLE indextest (id serial, stuff text); -- insert loads of values with intermittent sets of less common ...
    Thom BrownThom Brown
    Apr 5, 2011 at 10:36 pm
    Apr 7, 2011 at 8:02 am
  • Hi, I have done migration of the Request Tracker 3.8.9 (http://requesttracker.wikia.com/wiki/HomePage) from Mysql to PostgreSQL in testing environment. The RT schema used can be viewed at ...
    Václav OvsíkVáclav Ovsík
    Apr 12, 2011 at 11:31 pm
    Apr 15, 2011 at 7:59 am
  • How the tables must be ordered in the list of tables in from statement?
    Rishabh Kumar JainRishabh Kumar Jain
    Apr 28, 2011 at 9:20 am
    May 4, 2011 at 5:31 am
  • Howdy. We've got a query that takes less than a second unless we add a "order by" to it, after which it takes 40 seconds. Here's the query: select page_number, ps_id, ps_page_id from ps_page where ...
    Wayne ConradWayne Conrad
    Apr 29, 2011 at 6:29 pm
    May 2, 2011 at 4:31 pm
  • I have a database that contains many tables, each with some common characteristics. For legacy reasons, they have to be implemented in a way so that they are *all* searchable by an older identifier ...
    Lucas MadarLucas Madar
    Apr 11, 2011 at 9:11 pm
    Jun 30, 2011 at 7:07 pm
  • I browsed the faq and looked at PostgreSQL performance books but I could not find the obvious: How to configure a read-only database server? I have a single-disk virtual Linux system and a read-only ...
    Stefan KellerStefan Keller
    Apr 18, 2011 at 10:10 pm
    Apr 24, 2011 at 12:37 pm
  • Hi, I am trying to tune a query that is taking too much time on a large dataset (postgres 8.3). SELECT DISTINCT role_user.project_id AS projectId, sfuser.username AS adminUsername, sfuser.full_name ...
    Anne RossetAnne Rosset
    Apr 9, 2011 at 1:42 am
    Apr 13, 2011 at 9:37 pm
  • Hi everybody, I have a performance-problem with a query using a LIMIT. There are other threads rergading performance issues with LIMIT, but I didn't find useful hints for our problem and it might be ...
    Dieter RehbeinDieter Rehbein
    Apr 12, 2011 at 5:28 am
    Apr 12, 2011 at 2:38 pm
  • Sorry for resurrecting this thread, but this has been in my outbox for months and I think it is important: On Oct 27, 2010, at 12:56 PM, Tom Lane wrote: Scott Carey writes: Why does hashjoin behave ...
    Scott CareyScott Carey
    Apr 13, 2011 at 5:08 pm
    May 12, 2011 at 3:21 am
  • Dear all When database files are on a VxFS filesystem, performance can be significantly improved by setting the VX_CONCURRENT cache advisory on the file according to vxfs document, my question is ...
    HSIEN-WEN CHUHSIEN-WEN CHU
    Apr 28, 2011 at 3:42 am
    May 6, 2011 at 10:53 am
  • Can pgpoolAdmin utility handle(administer) more than one pgpool-II custer? We have a need of setting up 3 independent postgres clusters. One cluster handling cadastral maps, one handling raster maps ...
    JorgenJorgen
    Apr 29, 2011 at 1:02 pm
    May 3, 2011 at 8:16 am
  • Hei: We have PostgreSQL 8.3 running on Debian Linux server. We built an applicantion using PHP programming language and Postgres database. There are appoximatly 150 users using the software ...
    Qiang WangQiang Wang
    Apr 29, 2011 at 7:13 am
    May 1, 2011 at 4:18 pm
  • When I do a query on a table with child tables on certain queries pg uses indexes and on others it doesn't. Why does this happen? For example: [local]:playpen= explain analyze select * from vis where ...
    Joseph ShraibmanJoseph Shraibman
    Apr 1, 2011 at 12:53 am
    Apr 29, 2011 at 10:53 pm
  • Hi All, I am a new comer on postgres world and now using it for some serious (at least for me) projects. I have a need where I am running some analytical + aggregate functions on data where ordering ...
    Dhimant PatelDhimant Patel
    Apr 27, 2011 at 3:28 pm
    Apr 27, 2011 at 6:34 pm
  • We are experiencing a problem with our query plans when using a range query in Postgresql 8.3. The query we are executing attempts to select the minimum primary key id after a certain date. Our date ...
    Mark WilliamsMark Williams
    Apr 15, 2011 at 5:25 pm
    Apr 15, 2011 at 10:32 pm
  • Dear ,all plz could any one help me !!! how explian works as math equations to estimate cost with constatn query parameters such as cpu_tuple cost ,random page cost ...etc i want maths expression in ...
    Radhya sahalRadhya sahal
    Apr 11, 2011 at 11:02 pm
    Apr 13, 2011 at 8:19 pm
  • Hi all I'm trying to track down the causes of an application crash and reviewing PG logs I'm seeing this: 2011-04-22 06:00:16 CEST LOG: checkpoint complete: wrote 140 buffers (3.4%); 0 transaction ...
    DrvilloDrvillo
    Apr 22, 2011 at 9:21 am
    May 13, 2011 at 2:10 am
  • I'm running pgsql on an m1.large EC2 instance with 7.5gb available memory. The free command shows 7gb of free+cached. My understand from the docs is that I should dedicate 1.75gb to shared_buffers ...
    Joel ReymontJoel Reymont
    Apr 26, 2011 at 3:20 pm
    May 13, 2011 at 12:10 am
  • Hi, we are facing a performance issue on Postgres 8.4, the CPU reaches 100% with less than 50 simultaneous users. We were thinking to migrate the HR system from Oracle to Postgres but now that we ...
    Allen SooredooAllen Sooredoo
    Apr 20, 2011 at 3:56 pm
    Apr 25, 2011 at 11:44 pm
  • Hi, I'm using PostgreSQL 8.4 (and also 8.3). A partial index like this: CREATE INDEX table2_field1_idx ON table2 (field1) WHERE NOT field1 ISNULL; Will not be used when select one record from 100K ...
    Willy-Bas LoosWilly-Bas Loos
    Apr 20, 2011 at 8:47 am
    Apr 23, 2011 at 3:45 pm
  • Hi List, I am using PostgreSQL 9.0.3 and I have a need to dump only the selective data from partial list of tables of a database. Is there a straight way to do it with pg_dump or any alternative work ...
    Sethu PrasadSethu Prasad
    Apr 18, 2011 at 3:05 pm
    Apr 18, 2011 at 4:33 pm
  • Dear ,all i would to ask you about how postgresql optimizer parameters :- 1- random page cost 2- cpu tuple cost3- cpu operator cost4- cpu index tuple cost5- effective cache size play as parameters in ...
    Radhya sahalRadhya sahal
    Apr 10, 2011 at 6:23 pm
    Apr 11, 2011 at 2:41 am
  • Dear all, I want to clear my doubts regarding creating several single or a multi-column indexes. My table schema is :- CREATE TABLE svo2( svo_id bigint NOT NULL DEFAULT ...
    Adarsh SharmaAdarsh Sharma
    Apr 5, 2011 at 10:27 am
    Apr 6, 2011 at 6:55 am
  • This is a good one :) Here is a "brief" description of our issue(Postgres 9.0): Tables: main fact table: Table "public.parent_fact" Column | Type | ...
    Paul PiercePaul Pierce
    Apr 22, 2011 at 1:26 am
    Apr 25, 2011 at 6:11 pm
  • Hi all: I realize this is slightly off topic, but is an issue of concern with the use of ssd's. We are setting up a storage server under solaris using ZFS. We have a couple of ssd's 2 x 160GB Intel ...
    John RouillardJohn Rouillard
    Apr 22, 2011 at 2:04 pm
    Apr 23, 2011 at 2:47 am
  • Hi all: An application running against a postgres 8.4.5 database under CentOS 5.5 uses cursors (I think via SqlAlchemy). To look for database performance issues I log any query that takes 2 seconds ...
    John RouillardJohn Rouillard
    Apr 18, 2011 at 7:16 pm
    Apr 18, 2011 at 7:41 pm
  • I have two servers one has replication the other does not. The same query on both servers. One takes 225seconds on the replicated server the first time it runs and only 125ms on the other server the ...
    Ozer, PamOzer, Pam
    Apr 11, 2011 at 11:28 pm
    Apr 12, 2011 at 2:33 pm
  • Hi All, I have setup postgres 9 master slave streaming replication but experiencing slave lagging sometimes by 50 min to 60 min. I am not getting exact reason for slave lag delay. Below are the ...
    Saurabh AgrawalSaurabh Agrawal
    Apr 11, 2011 at 6:29 pm
    Apr 11, 2011 at 10:39 pm
  • I have a PL/PGSQL stored procedure on my server which is about 3,500 lines long. To further improve performance after more than year of optimizing the PL/PGSQL, and also to hide the logic so it is ...
    Eliot GableEliot Gable
    Apr 2, 2011 at 6:52 pm
    Apr 3, 2011 at 7:02 am
  • Is there a reason that when executing queries the table constraints are only checked during planning and not execution? I end up making 2 round trips to the database to get around this. All of these ...
    Joseph ShraibmanJoseph Shraibman
    Apr 1, 2011 at 12:53 am
    Apr 1, 2011 at 5:32 pm
  • Folks, I'm trying to optimize the following query that performs KL Divergence [1]. As you can see the distance function operates on vectors of 150 floats. The query takes 12 minutes to run on an idle ...
    Joel ReymontJoel Reymont
    Apr 26, 2011 at 3:21 pm
    Apr 26, 2011 at 3:21 pm
  • So sometime along yellow brick firmware road HP changed (and maybe your vendor did too) the output of what happens when the write cache is off due to failed batteries attached to the card/cache. (and ...
    MarkMark
    Apr 21, 2011 at 2:14 am
    Apr 21, 2011 at 2:14 am
  • http%3A%2F%2Fwww%2Eproductionsoundmixer%2Eorg%2Fimages%2Famw%2Ephp
    Whatever DeepWhatever Deep
    Apr 8, 2011 at 5:37 pm
    Apr 8, 2011 at 5:37 pm
  • Database Test Suite H o w are you all ?? I am new in this group. I have windows 7 as OS and i installed postgresql 9.0 i want a to do some tests so i need bench mark to test some workloads? i need ...
    Radhya sahalRadhya sahal
    Apr 8, 2011 at 2:51 pm
    Apr 8, 2011 at 2:51 pm
Group Navigation
period‹ prev | Apr 2011 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions48
posts450
users114
websitepostgresql.org
irc#postgresql

114 users for April 2011

Scott Marlowe: 33 posts Claudio Freire: 27 posts Kevin Grittner: 26 posts Greg Smith: 25 posts Tomas Vondra: 23 posts Robert Haas: 22 posts Tom Lane: 18 posts Scott Carey: 13 posts Glyn Astill: 11 posts Merlin Moncure: 11 posts Tory M Blue: 11 posts Joshua Berkus: 10 posts Adarsh Sharma: 8 posts Joel Reymont: 8 posts Ireneusz Pluta: 7 posts Laurent Laborde: 7 posts Phoenix Kiula: 7 posts Cédric Villemain: 6 posts Gnuoytr: 5 posts Achilleas Mantzios: 5 posts
show more
Archives