FAQ

PostgreSQL > pgsql-performance > February 2010

Search Discussions

52 discussions - 403 posts

  • I took a look at this patch today and I agree with Tom that pg_fsync_start() is a very confusing name. I don't know what the right name is, but this doesn't fsync so I don't think it shuld have fsync ...
    Robert HaasRobert Haas
    Feb 2, 2010 at 6:49 pm
    Feb 11, 2010 at 2:27 am
  • Recently I've made a number of unsubstantiated claims that the deadline scheduler on Linux does bad things compared to CFQ when running real-world mixed I/O database tests. Unfortunately every time I ...
    Greg SmithGreg Smith
    Feb 8, 2010 at 9:45 am
    Feb 16, 2010 at 9:33 pm
  • I've got a very slow query, which I can make faster by doing something seemingly trivial. The query has been trouble for years (always slow, sometimes taking hours): 512,600ms Original, filter on ...
    Bryce NesbittBryce Nesbitt
    Feb 10, 2010 at 4:34 am
    Feb 15, 2010 at 4:42 pm
  • Due to an error during an update to the system kernel on a database server backing a web application, we ran for a month (mid-December to mid-January) with the WAL files in the pg_xlog subdirectory ...
    Kevin GrittnerKevin Grittner
    Feb 9, 2010 at 4:14 pm
    Feb 23, 2010 at 10:14 pm
  • Okay ladies and gents and the rest of you :) It's time I dig into another issue, and that's a curious 5 second delay on connect, on occasion. Now, I believe the network to be sound and there are zero ...
    Tory M BlueTory M Blue
    Feb 26, 2010 at 6:12 am
    Mar 3, 2010 at 7:34 pm
  • This is a generic SQL issue and not PG specific, but I'd like to get an opinion from this list. Consider the following data: # \d bar Table "public.bar" Column | Type | Modifiers ...
    Dave CrookeDave Crooke
    Feb 24, 2010 at 9:31 pm
    Mar 9, 2010 at 4:13 pm
  • Hello I have a server dedicated for Postgres with the following specs: RAM 16GB, 146GB SAS (15K) x 4 - RAID 10 with BBU, Dual Xeon E5345 @ 2.33GHz OS: FreeBSD 8.0 It runs multiple (approx 10) ...
    Amitabh KantAmitabh Kant
    Feb 3, 2010 at 3:13 pm
    Feb 4, 2010 at 11:20 am
  • Some informations: The following problem has been detected on Postgresql 8.3 and 8.4. on System linux or windows Default AutoVacuum daemon working One pg_dump every day This happens sometimes and i ...
    Lionel duboeufLionel duboeuf
    Feb 12, 2010 at 1:35 pm
    Feb 16, 2010 at 4:47 pm
  • pg 8.3.9, Debian Etch, 8gb ram, quadcore xeon, megaraid (more details at end) ~240 active databases, 800+ db connections via tcp. Everything goes along fairly well, load average from 0.5 to 4.0. Disk ...
    RobRob
    Feb 2, 2010 at 8:17 pm
    Feb 4, 2010 at 2:18 am
  • Hello: I'm an ignorant in what refers to performance analysis of PostgreSQL. I've a doubt about how the PostgreSQL planner makes a hash join. I've tried to "dig" into the archive of this mailing list ...
    NegoraNegora
    Feb 23, 2010 at 2:45 pm
    Feb 24, 2010 at 2:46 pm
  • Just a heads up - apparently the more recent Dell RAID controllers will no longer recognise hard discs that weren't sold through Dell. ...
    Matthew WakelingMatthew Wakeling
    Feb 11, 2010 at 12:39 pm
    Feb 17, 2010 at 1:08 pm
  • Hi all, i am trying to move my app from M$sql to PGsql, but i need a bit of help :) on M$sql, i had certain tables that was made as follow (sorry pseudo code) contab_y date amt uid contab_yd date amt ...
    RamaRama
    Feb 10, 2010 at 10:19 pm
    Feb 11, 2010 at 2:39 pm
  • Hi, I am running a bunch of queries within a function, creating some temp tables and populating them. When the data exceeds say, 100k the queries start getting really slow and timeout (30 min). when ...
    Mridula MahadevanMridula Mahadevan
    Feb 2, 2010 at 6:53 pm
    Feb 3, 2010 at 8:06 pm
  • hi, first, thanks u for make so good opensource db . recently maybe half an years ago ,i begin to use pg in a big project for insurance project, belong as the project go on ,and i found some ...
    Wyx6foxWyx6fox
    Feb 2, 2010 at 4:57 am
    Feb 3, 2010 at 8:32 am
  • Hi, I'm having an issue where a postgres process is taking too much memory when performing many consecutive inserts and updates from a PHP script (running on the command line). I would like to know ...
    ChrisChris
    Feb 27, 2010 at 10:29 pm
    Feb 28, 2010 at 4:42 pm
  • Hi, I'm using postgresql 8.4 I need to install multiple postgresql dbs on one server but I have some questions: -Is there any problems (performance wise or other) if I have 10 to 15 DBs on the same ...
    Elias ghanemElias ghanem
    Feb 26, 2010 at 11:34 am
    Feb 26, 2010 at 2:49 pm
  • Hi, I am trying to make a select query in my plpgsql function to use an index allowing an index scan instead of a seq scan. When running the query in the sql prompt, it works fine, but apparently the ...
    Joel JacobsonJoel Jacobson
    Feb 22, 2010 at 7:29 pm
    Feb 22, 2010 at 10:18 pm
  • "Not like" operation does not use index. select * from vtiger_contactscf where lower(cf_1253) not like lower('Former%') I created index on lower(cf_1253). How can I ensure index usage in not like ...
    AI RummanAI Rumman
    Feb 18, 2010 at 11:56 am
    Feb 18, 2010 at 12:44 pm
  • (Apologies if this ends up coming through multiple times - my first attempts seem to have gotten stuck.) We recently took the much needed step in moving from 8.1.19 to 8.4.2. We took the downtime ...
    Ben ChobotBen Chobot
    Feb 14, 2010 at 6:39 pm
    Feb 17, 2010 at 5:34 am
  • foreign key constraint lock behavour : The referenced FK row would be added some exclusive lock , following is the case: CREATE TABLE tb_a ( id character varying(255) NOT NULL, "name" character ...
    WangyuxiangWangyuxiang
    Feb 4, 2010 at 4:05 am
    Feb 9, 2010 at 3:24 pm
  • All, I'm seeing in a production database two problems with query rowcount estimation: (1) Estimates for the number of rows in an outer join do not take into account any constraint exclusion (CE) in ...
    Josh BerkusJosh Berkus
    Feb 28, 2010 at 8:20 pm
    Mar 8, 2010 at 9:56 pm
  • Hi All; I have a table that has daily partitions. The check constraints look like this: CHECK (timezone('EST'::text, insert_dt) = '2010-01-01'::date AND timezone('EST'::text, insert_dt) < ...
    Kevin KempterKevin Kempter
    Feb 24, 2010 at 2:36 pm
    Feb 28, 2010 at 10:47 pm
  • Good day, I have a PostgreSQL 8.4 database installed on WinXP x64 with very heavy writing and updating on a partitioned table. Sometimes within one minute, there are tens of file with ...
    Rose ZhouRose Zhou
    Feb 15, 2010 at 8:00 pm
    Feb 17, 2010 at 7:58 pm
  • Hi, I have seen some work done about scaling PostgreSQL on SMP machines and see that PostgreSQL has been executed on several numbers of cores. I have some questions about scaling PostgreSQL on SMP ...
    Reydan CankurReydan Cankur
    Feb 14, 2010 at 4:36 pm
    Feb 15, 2010 at 2:33 pm
  • Hello all, Apologies for the long mail. I work for a company that is provides solutions mostly on a Java/Oracle platform. Recently we moved on of our products to PostgreSQL. The main reason was ...
    Jayadevan MJayadevan M
    Feb 10, 2010 at 4:11 am
    Feb 10, 2010 at 3:55 pm
  • I have a relatively straightforward query that by itself isn't that slow, but we have to run it up to 40 times on one webpage load, so it needs to run much faster than it does. Here it is: SELECT ...
    Matt WhiteMatt White
    Feb 2, 2010 at 1:23 am
    Feb 5, 2010 at 1:49 am
  • Greetings, I have a column that is a bigint that needs to store integers up to 19 digits long. For the most part this works but we sometimes have numbers that are greater than 9223372036854775807. I ...
    Tory M BlueTory M Blue
    Feb 4, 2010 at 6:16 pm
    Feb 4, 2010 at 8:09 pm
  • Hi, I have a couple of questions about dbt2 performance. 1. I tested dbt2+postgresql 8.4.2 on my server, but the NOTPM is around only 320~390 with 10 connections and 30 warehouses. Increasing the ...
    Yu-Ju HongYu-Ju Hong
    Feb 25, 2010 at 9:27 pm
    Mar 3, 2010 at 5:09 pm
  • I have a system with around 330 databases running PostgreSQL 8.4.2 What would the expected behavior be with AutoVacuum_NapTime set to the default of 1m and autovacuum_workers set to 3? What I'm ...
    George SextonGeorge Sexton
    Feb 21, 2010 at 1:03 am
    Feb 22, 2010 at 12:44 pm
  • hi, STACK_DEPTH_SLOP stands for Required daylight between max_stack_depth and the kernel limit, in bytes. Why we need so much memory? MySql need only no more than 100K. Where these memory allocated ...
    TerryTerry
    Feb 21, 2010 at 3:05 am
    Feb 21, 2010 at 5:45 am
  • Since getting on 8.4 I've been monitoring things fairly closely. I whipped up a quick script to monitor pg_stat_bgwriter and save deltas every minute so I can ensure my bgwriter is beating out the ...
    JeffJeff
    Feb 17, 2010 at 1:31 pm
    Feb 18, 2010 at 1:37 pm
  • Please have a look at the following explain plan: explain analyze select * from vtiger_crmentity inner JOIN vtiger_users ON vtiger_users.id = vtiger_crmentity.smownerid where vtiger_crmentity.deleted ...
    AI RummanAI Rumman
    Feb 15, 2010 at 9:35 am
    Feb 15, 2010 at 3:32 pm
  • Hi, I am trying to improve delete performance on a database with several foreign keys between relations that have 100M or so rows. Until now, I have manually disabled the triggers, done the delete, ...
    Franck RoutierFranck Routier
    Feb 10, 2010 at 11:01 am
    Feb 14, 2010 at 11:21 am
  • and should generate equivalent plans, in such cases: SELECT DISTINCT x FROM mytable SELECT x FROM mytable GROUP BY x However, in my case (postgresql-server-8.1.18-2.el5_4.1), they generated different ...
    Dimi PaunDimi Paun
    Feb 9, 2010 at 10:12 pm
    Feb 10, 2010 at 1:44 am
  • I have created a index create index leadaddress_phone_idx on leadaddress(regexp_replace((phone)::text, '[^0-9]*'::text, ''::text, 'g'::text)); But the index is not using. explain select * from ...
    AI RummanAI Rumman
    Feb 9, 2010 at 8:12 am
    Feb 9, 2010 at 9:44 am
  • Sorry again for previous rough messages,&nbsp; some good people advice me to post these problems again With sincere and friendly attitude 。 I think i should do this . In recently projects , I ...
    Wyx6foxWyx6fox
    Feb 3, 2010 at 2:28 am
    Feb 4, 2010 at 7:30 am
  • Let's say you have one partitioned table, "tbl_p", partitioned according to the PK "p_pk". I have made something similar with triggers, basing myself on the manual for making partitioned tables. ...
    Davor J.Davor J.
    Feb 2, 2010 at 9:49 am
    Feb 3, 2010 at 3:54 pm
  • I am getting seq_scan on vtiger_account. Index is not using. Could anyone please tell me what the reason is? explain analyze select * from vtiger_account LEFT JOIN vtiger_account vtiger_account2 ON ...
    AI RummanAI Rumman
    Feb 16, 2010 at 11:43 am
    Feb 16, 2010 at 2:56 pm
  • Can anybody briefly explain me how each postgres process allocate memory for it needs? I mean, what is the biggest size of malloc() it may want? How many such chunks? What is the average size of ...
    Anton MaksimenkovAnton Maksimenkov
    Feb 10, 2010 at 5:10 am
    Feb 11, 2010 at 3:47 am
  • Dear Postgres Community, I'm running postgres 8.3 I have a table, partitioned by month -- Table: datadump -- DROP TABLE datadump; CREATE TABLE datadump ( sys_timestamp timestamp without time zone, ...
    WojtekWojtek
    Feb 5, 2010 at 12:38 pm
    Feb 5, 2010 at 6:30 pm
  • hi, first, thanks u for make so good opensource db . &nbsp; recently maybe half an years ago ,i begin to use pg in a big project for insurance project, belong as the project go on ,and i found some ...
    Wyx6foxWyx6fox
    Feb 2, 2010 at 4:52 am
    Feb 2, 2010 at 7:04 pm
  • Xufei, List changed to psql-performance, which is where this discussion belongs. Because the row estimates changed, since 8.4 improved row estimation for TSearch. The 2nd query is probably actually ...
    Josh BerkusJosh Berkus
    Feb 28, 2010 at 10:42 pm
    Mar 1, 2010 at 3:16 am
  • Hi folks I have an application which collects performance stats at time intervals, to which I am retro-fitting a table partitioning scheme in order to improve scalability. The original data is keyed ...
    Dave CrookeDave Crooke
    Feb 23, 2010 at 3:01 am
    Feb 23, 2010 at 5:23 am
  • I'm reading the docs for 8.4.2, section 18.4.1 Memory. I'm trying to figure out what reasonable values for my usage would be. The doc says: shared_buffers (integer) Sets the amount of memory the ...
    George SextonGeorge Sexton
    Feb 22, 2010 at 3:05 pm
    Feb 22, 2010 at 3:23 pm
  • Good day! We bought a new WinXP x64 Professional, it has 12GB memory. I installed postgresql-8.4.1-1-windows version on this PC, also installed another .Net application which reads in data from a TCP ...
    Rose ZhouRose Zhou
    Feb 15, 2010 at 8:20 pm
    Feb 21, 2010 at 6:44 pm
  • I'm having problems with another one of my queries after moving from 8.1.19 to 8.4.2. On 8.1.19, the plan looked like this: http://wood.silentmedia.com/bench/8119 That runs pretty well. On 8.4.2, the ...
    Ben ChobotBen Chobot
    Feb 16, 2010 at 9:30 pm
    Feb 16, 2010 at 11:39 pm
  • I have been trying to track down a performance issue we've been having with a INSERT INTO ... SELECT query run against a partitioned table on postgres. The problem appears to be in the plan building ...
    Connors, BillConnors, Bill
    Feb 12, 2010 at 4:20 pm
    Feb 12, 2010 at 6:20 pm
  • Hello guys, I don't know if this is the correct list. Correct me if I'm wrong. I have a directed graph, or better, a tree in postgresql 8.3. One table are the nodes and another one are the ...
    Luiz Angelo Daros de LucaLuiz Angelo Daros de Luca
    Feb 12, 2010 at 12:57 pm
    Feb 12, 2010 at 1:31 pm
  • I'm not familiar with the "code" that you are referring to. Do you have a hyper-link to it? Also, I'm not sure why you mentioned Tom's name here. Does he have anything to do with the "code" that ...
    Richard BroersmaRichard Broersma
    Feb 2, 2010 at 6:41 pm
    Feb 2, 2010 at 8:30 pm
  • Thanks Joe. 1. In my case, I'm erring on the side of not using the limited partitioning support in PG 8.3, which we're using .... because I'm generating new tables all the time, I need to dynamically ...
    Dave CrookeDave Crooke
    Feb 23, 2010 at 11:37 pm
    Feb 23, 2010 at 11:37 pm
Feb 2010
12
Group Navigation
period‹ prev | Feb 2010 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions52
posts403
users100
websitepostgresql.org
irc#postgresql

100 users for February 2010

Kevin Grittner: 27 posts Greg Smith: 25 posts Robert Haas: 22 posts Tom Lane: 21 posts Scott Marlowe: 18 posts Bruce Momjian: 13 posts Andres Freund: 12 posts Alvaro Herrera: 10 posts Ben Chobot: 10 posts Dave Crooke: 10 posts Tory M Blue: 10 posts Amitabh Kant: 9 posts David: 7 posts Bryce Nesbitt: 7 posts Lionel duboeuf: 7 posts Glenn Maynard: 6 posts Pierre Frédéric Caillaud: 6 posts Scott Carey: 6 posts Yeb Havinga: 6 posts AI Rumman: 5 posts
show more
Archives