Search Discussions

50 discussions - 457 posts

  • Hi, I want to fine tune my postgresql to increase number of connects it can handle in a minutes time. Decrease the response time per request etc. The exact case will be to handle around 100 ...
    Harpreet singh WadhwaHarpreet singh Wadhwa
    Jul 8, 2010 at 7:20 pm
    Jul 29, 2010 at 5:39 pm
  • Hello list, Probably like many other's I've wondered why no SSD manufacturer puts a small BBU on a SSD drive. Triggered by Greg Smith's mail ...
    Yeb HavingaYeb Havinga
    Jul 24, 2010 at 7:19 am
    Aug 11, 2010 at 10:31 pm
  • Postgresql was previously running on a single cpu linux machine with 2 gigs of memory and a single sata drive (v8.3). Basically a desktop with linux on it. I experienced slow performance. So, I ...
    Ryan WexlerRyan Wexler
    Jul 7, 2010 at 11:12 pm
    Jul 16, 2010 at 4:55 pm
  • I have spent the last couple of weeks digging into a Postgres performance problem that ultimately boiled down to this: the planner was choosing to use hash joins on a set of join keys that were much ...
    Peter HusseyPeter Hussey
    Jul 27, 2010 at 11:34 pm
    Feb 1, 2011 at 8:24 pm
  • I have a long stored procedure (over 3,000 lines). Originally, it would take about 44ms to run the whole query. After lots and lots of tweaking, Postgres now runs the entire thing and gathers my ...
    Eliot GableEliot Gable
    Jul 2, 2010 at 12:46 am
    Jul 7, 2010 at 7:42 pm
  • Hi, I have a question concerning the uses of indexes in Postgresql. I red that in PG a query can not use more than one index per table: "a query or data manipulation command can use at most one index ...
    Elias GhanemElias Ghanem
    Jul 21, 2010 at 7:31 am
    Jul 25, 2010 at 8:29 am
  • Hi everyone, I'm running 8.4.2 on a CentOS machine, and postgres recently died with signal 6 because the pg_xlog partition filled up (33GB) on 7/4/10 10:34:23 (perfect timing, as I was hiking in the ...
    Richard YenRichard Yen
    Jul 7, 2010 at 1:10 am
    Jul 9, 2010 at 11:24 pm
  • I have two servers with equal specs, one of them running 8.3.7 and the new server running 8.4.4. The only tweak I have made from the default install (from Ubuntu repositories) is increasing ...
    Patrick DonlinPatrick Donlin
    Jul 15, 2010 at 2:48 pm
    Jul 16, 2010 at 2:17 pm
  • Here's a query and its EXPLAIN ANALYZE output: cms= select count(*) from forum; count ------- 90675 (1 row) cms= explain analyze select id,title from forum where _fts_ @@ 'fer'::tsquery; QUERY PLAN ...
    Ivan VorasIvan Voras
    Jul 14, 2010 at 11:47 am
    Jul 14, 2010 at 8:26 pm
  • Hi all, I'm using Postgresql 8.4.4 on Debian. In postgresql.conf, constraint_exclusion is set to "on" I have partitioned tables with check constraints. My primary table : CREATE TABLE documents ( id ...
    Philippe RimbaultPhilippe Rimbault
    Jul 22, 2010 at 7:51 am
    Aug 4, 2010 at 1:16 pm
  • Hello, I try to make a query run quicker but I don't really know how to give hints to the planner. We are using postgresql 8.4.3 64bit on ubuntu 9.10 server. The hardware is a 10 SAS drive (15k) on a ...
    Damien hostinDamien hostin
    Jul 2, 2010 at 8:59 am
    Jul 22, 2010 at 6:09 pm
  • Hello, I've found strange problem in my database (8.4.4, but also 9.0beta3, default postgresql.conf, shared_buffers raised to 256MB). EXPLAIN ANALYZE SELECT ... Total runtime: 4.782 ms Time: 25,970 ...
    Piotr GasidłoPiotr Gasidło
    Jul 26, 2010 at 8:35 am
    Jul 28, 2010 at 11:07 am
  • Hi, I need to log the start and end time of the procedures in a table. But the start and end time are same. This is how I recreated the issue. create table test_time (time timestamp); delete from ...
    Atul GoelAtul Goel
    Jul 12, 2010 at 11:09 am
    Jul 18, 2010 at 8:54 am
  • I'm involved with the setup of replacement hardware for one of our systems. It is going to be using Ubuntu Lucid Server (kernel 2.6.32 I believe). The issue of filesystems has raised its head again. ...
    Mark KirkwoodMark Kirkwood
    Jul 27, 2010 at 5:04 am
    Jul 27, 2010 at 6:32 pm
  • Hi, I've trouble with some SQL request which have different execution plans when ran on two different servers. One server is the development environment, the othe rone is th pre-production env. Both ...
    JOUANIN Nicolas (44)JOUANIN Nicolas (44)
    Jul 7, 2010 at 8:00 am
    Jul 7, 2010 at 12:34 pm
  • Hi people, I have a particular performance problem under a system installed. In the lab I have an old Microside + Dual Core machine 1GB RAM with 40gb HD IDE and a newer machine HP DL 380 G5 4GB RAM ...
    Daniel Ferreira de LimaDaniel Ferreira de Lima
    Jul 19, 2010 at 12:24 pm
    Jul 20, 2010 at 10:57 pm
  • Hi, My question is regarding ORDER BY / LIMIT query behavior when using partitioning. I have a large table (about 100 columns, several million rows) partitioned by a column called day (which is the ...
    Ranga GopalanRanga Gopalan
    Jul 2, 2010 at 3:28 pm
    Jul 6, 2010 at 9:02 pm
  • Hi, this is not really a performance question , sorry if its bit irrelevant to be posted here. We have a development environment and we want to optimize the non-database parts of the application. The ...
    Rajesh Kumar MallahRajesh Kumar Mallah
    Jul 1, 2010 at 9:41 am
    Jul 5, 2010 at 9:55 am
  • Hi there, I have a simple query where I don't understand the planner's choice to use a particular index. The main table looks like this: # \d sq_ast_attr_val Table "public.sq_ast_attr_val" Column | ...
    Jul 29, 2010 at 12:51 am
    Jul 29, 2010 at 3:21 pm
  • Hi, I have a situation to handle a log table which would accumulate a large amount of logs. This table only involves insert and query operations. To limit the table size, I tried to split this table ...
    Jul 19, 2010 at 6:27 am
    Jul 27, 2010 at 9:17 pm
  • Hi there. I think I found a potential performance gain if the query planner would be optimized. All Tests has been performed with 8.4.1 (and earlier versions) on CentOS 5.3 (x64) The following query ...
    Kneringer, ArminKneringer, Armin
    Jul 20, 2010 at 4:48 pm
    Jul 27, 2010 at 6:25 pm
  • Hi, I have quite a simple query but a lot of data and the SELECT query is too slow. I will be really grateful for any advice on this. -------------------------------------------------- The background ...
    Michal FapsoMichal Fapso
    Jul 1, 2010 at 10:35 pm
    Jul 7, 2010 at 8:49 pm
  • I am sending u the query along with execution plan. Please help explain analyze select s.*,a.actid,a.phone,d.domid,d.domname,d.domno,a.actno,a.actname,p.descr as svcdescr from vwsubsmin s inner join ...
    Jul 17, 2010 at 8:51 am
    Jul 27, 2010 at 6:11 pm
  • First of all, a little background. We have a table which is used as a trigger table for entering and processing data for a network monitoring system. Essentially, we insert a set of columns into a ...
    Benjamin KrajmalnikBenjamin Krajmalnik
    Jul 15, 2010 at 5:32 pm
    Jul 16, 2010 at 12:24 am
  • Hi, I have table "ARTICLE" containing a String a field "STATUS" that represents a number in binary format (for ex: 10011101). My application issues queries with where conditions that uses BITAND ...
    Elias GhanemElias Ghanem
    Jul 13, 2010 at 12:17 pm
    Jul 14, 2010 at 2:53 pm
  • Hello all, One doubt about how PostgreSQL PITR works. Let us say I have all the archived WALs for the past week with archive_command = 'cp -i %p /home/postgres/archive/%f </dev/null' I took a base ...
    Jayadevan MJayadevan M
    Jul 12, 2010 at 11:24 am
    Jul 12, 2010 at 12:28 pm
  • Hi, We are using dbt2 to check performance of postgresql 8.4 on Linux64 machine. When we increase "TERMINALS PER WAREHOUSE" TPM value increase rapidly but rampup time increase too , dbt2 estimated ...
    Jul 2, 2010 at 2:39 pm
    Jul 7, 2010 at 12:35 am
  • Hello everyone, We've recently finished developing a bigger webapplication, and we are about to put it online. I ran some load tests yesterday, and configured 'slow query' logging beforehand, so I ...
    Jens HoffrichterJens Hoffrichter
    Jul 5, 2010 at 11:36 am
    Jul 6, 2010 at 3:19 am
  • Hi all.. Can any one help me? I'd like to know how can we get the following information in PostgreSQL: Execution plan The I/O physical reads and logical reads, CPU consumption, number of DB block ...
    Std pikStd pik
    Jul 23, 2010 at 4:25 am
    Aug 4, 2010 at 3:30 am
  • Dear postgresql list, I have some troubles generating data for a analysis task at hand. I have a table (table A) containing 5 million records and 28 number of attributes. This table is 461MB big if I ...
    Dino VlietDino Vliet
    Jul 29, 2010 at 9:59 pm
    Jul 30, 2010 at 10:48 am
  • Hello, I have a simple table which has a cube column and a cube GiST index. The column contains 3-dimensional points (not cubes or intervals). The problem is that I'm getting very slow queries when ...
    Liviu Mirea-GhibanLiviu Mirea-Ghiban
    Jul 25, 2010 at 10:35 am
    Jul 27, 2010 at 10:19 pm
  • I have a table. \d email_track Table "public.email_track" Column | Type | Modifiers --------+---------+-------------------- crmid | integer | not null default 0 mailid | integer | not null default 0 ...
    AI RummanAI Rumman
    Jul 22, 2010 at 8:05 am
    Jul 22, 2010 at 8:16 am
  • Hi All; we have a table partitioned by day, the check constraint on the child tables looks like this (this is the may 31st partition): CHECK (stime = '2010-05-30 00:00:00+00'::timestamp with time ...
    Kevin KempterKevin Kempter
    Jul 20, 2010 at 3:42 pm
    Jul 20, 2010 at 3:56 pm
  • I'm having trouble getting the query planner to use indexes. The situation occurs when writing a query that uses functions for defining the parameters for the conditions on the indexed columns. The ...
    Jeremy PalmerJeremy Palmer
    Jul 9, 2010 at 10:46 pm
    Jul 10, 2010 at 12:26 am
  • Hello. I have a tree-like table with a three-field PK (name, date, id) and one parent field. It has 5k to 6k records as of now, but it will hold about 1 million records. I am trying the following ...
    Octavio AlvarezOctavio Alvarez
    Jul 5, 2010 at 7:31 am
    Jul 7, 2010 at 1:14 pm
  • Hi, We are using postgresql-8.4.0 on 64-bit Linux machine (open-SUSE 11.x). It's a master/slave deployment & slony-2.0.4.rc2 is used for DB replication (from master to slave). At times we have ...
    Sachin KumarSachin Kumar
    Jul 2, 2010 at 5:40 am
    Jul 6, 2010 at 12:35 am
  • Please tell me What is the best way to optimize this query select s.*,a.actid,a.phone,d.domid,d.domname,d.domno,a.actno,a.actname,p.descr as svcdescr from vwsubsmin s inner join packages p on ...
    Srikanth KataSrikanth Kata
    Jul 1, 2010 at 5:19 am
    Jul 1, 2010 at 12:51 pm
  • There is a partitioned table with 2 partitions: drop table if exists p cascade; create table p ( id bigint not null primary key, ts timestamp); create table p_actual ( check (ts is null) ) inherits ...
    Vlad ArkhipovVlad Arkhipov
    Jul 26, 2010 at 9:07 am
    Jul 31, 2010 at 2:21 am
  • I'm wondering whether columns, in the select list of a view that is used in a join, which are not used either as join criteria or in the select list of the overall query, effect the performance of ...
    Eric SchwarzenbachEric Schwarzenbach
    Jul 30, 2010 at 3:02 pm
    Jul 30, 2010 at 3:11 pm
  • Hi, On a hunch I removed two (legacy) WHERE conditions from the following query I obtained a 158x speed improvement. Yet these condiditions do not filter anything. Does that make any sense? The ...
    Louis-David MitterrandLouis-David Mitterrand
    Jul 28, 2010 at 10:27 am
    Jul 28, 2010 at 10:49 am
  • Hi I need to configure for high performance and memory usage my postgres 8.4 clusters. Description: The database is partitioned in regions. Every region has master and slave db. The application ...
    Stanimir petrovStanimir petrov
    Jul 21, 2010 at 12:42 pm
    Jul 21, 2010 at 3:08 pm
  • Hello, I don't think this is generally solvable but maybe it is so here goes. The original situation was this: SELECT something, big_field, complex_function(big_field), rank FROM t1 UNION ALL SELECT ...
    Ivan VorasIvan Voras
    Jul 19, 2010 at 3:09 pm
    Jul 19, 2010 at 3:35 pm
  • I have a query: SELECT d1.ID, d2.ID FROM DocPrimary d1 JOIN DocPrimary d2 ON d2.BasedOn=d1.ID WHERE (d1.ID=234409763) or (d2.ID=234409763) i think what QO(Query Optimizer) can make it faster (now it ...
    Jul 15, 2010 at 6:18 am
    Jul 15, 2010 at 7:57 am
  • Hello. Today I've found out strange results for query below. select version(); version ---------------------------------------------------------------------------------------------------------- ...
    Віталій ТимчишинВіталій Тимчишин
    Jul 12, 2010 at 1:29 pm
    Jul 12, 2010 at 2:45 pm
  • -- HOSTIN Damien - Equipe R&D Tel:+33(0)4 63 05 95 40 Société Axège 23 rue Saint Simon 63000 Clermont Ferrand www.axege.com
    Damien hostinDamien hostin
    Jul 12, 2010 at 9:03 am
    Jul 12, 2010 at 9:05 am
  • On 8.1, I have a very interesting database where the distributions of some values in a multi-million rows table is logarithmic (i.e. the most frequent value is an order of magnitude more frequent ...
    Jerry GamacheJerry Gamache
    Jul 7, 2010 at 9:03 pm
    Jul 7, 2010 at 9:22 pm
  • Greetings, we are running a few databases of currently 200GB (growing) in total for data warehousing: - new data via INSERTs for (up to) millions of rows per day; sometimes with UPDATEs - most data ...
    Joachim WorringenJoachim Worringen
    Jul 1, 2010 at 1:14 pm
    Jul 1, 2010 at 2:15 pm
  • We are running 8.3.10 64bit. Compare the plans below. They all do the same thing and delete from a table named work_active (about 500rows), which is a subset of work_unit (about 50m rows). I want to ...
    Mark RostronMark Rostron
    Jul 31, 2010 at 2:27 am
    Jul 31, 2010 at 2:27 am
  • Green Peace - Climate body {font-family:Arial, Helvetica, sans-serif; font-weight:bold; font-size:12px; color:#999;} a {color:#CCCCCC; text-decoration:underline;} a:hover {color:#666; ...
    Jul 13, 2010 at 6:52 am
    Jul 13, 2010 at 6:52 am
  • LinkedIn ------------Gourish Singbal requested to add you as a connection on LinkedIn: ------------------------------------------ Dimi, I'd like to add you to my professional network on LinkedIn. - ...
    Gourish SingbalGourish Singbal
    Jul 7, 2010 at 6:33 am
    Jul 7, 2010 at 6:33 am
Group Navigation
period‹ prev | Jul 2010 | next ›
Group Overview
grouppgsql-performance @

113 users for July 2010

Kevin Grittner: 29 posts Greg Smith: 26 posts Robert Haas: 26 posts Tom Lane: 26 posts Craig Ringer: 20 posts Yeb Havinga: 18 posts Rajesh Kumar Mallah: 13 posts Eliot Gable: 10 posts Ryan Wexler: 10 posts Scott Marlowe: 10 posts Craig James: 8 posts Damien hostin: 8 posts Matthew Wakeling: 8 posts Andres Freund: 7 posts Ben Chobot: 7 posts Hannu Krosing: 7 posts Ivan Voras: 7 posts Joshua D. Drake: 7 posts Merlin Moncure: 7 posts Scott Carey: 7 posts
show more