FAQ

Search Discussions

65 discussions - 640 posts

  • Dear community, My company, which I actually represent, is a fervent user of PostgreSQL. We used to make all our applications using PostgreSQL for more than 5 years. We usually do classical ...
    Hervé PiedvacheHervé Piedvache
    Jan 20, 2005 at 2:03 pm
    Feb 18, 2005 at 11:27 pm
  • Hi to all, I have the following 2 examples. Now, regarding on the offset if it is small(10) or big( 50000) what is the impact on the performance of the query?? I noticed that if I return more ...
    Andrei BintintanAndrei Bintintan
    Jan 20, 2005 at 11:13 am
    Feb 1, 2005 at 11:39 am
  • I'm looking for recent performance statistics on PostgreSQL vs. Oracle vs. Microsoft SQL Server. Recently someone has been trying to convince my client to switch from SyBASE to Microsoft SQL Server ...
    Randolf RichardsonRandolf Richardson
    Jan 6, 2005 at 7:02 pm
    Jan 27, 2005 at 6:27 pm
  • I try to adjust my server for a couple of weeks with some sucess but it still slow when the server has stress in the moring from many connection . I used postgresql 7.3.2-1 with RH 9 on a mechine of ...
    AmritAmrit
    Jan 2, 2005 at 2:52 am
    Jan 6, 2005 at 8:22 pm
  • I'm sorry if there's a URL out there answering this, but I couldn't find it. For those of us that need the best performance possible out of a dedicated dual-CPU PostgreSQL server, what is ...
    Miles KeatonMiles Keaton
    Jan 11, 2005 at 2:42 am
    Mar 29, 2005 at 12:51 am
  • I wonder if I would like to increase more RAM from 4 Gb. to 6 Gb. [which I hope to increase more performance ] and I now I used RH 9 and Pgsql 7.3.2 ON DUAL Xeon 3.0 server thay has the limtation of ...
    AmritAmrit
    Jan 12, 2005 at 6:55 am
    Jan 19, 2005 at 1:40 pm
  • Hello, I'm running PostgreSQL on a Solaris 8 system with 2GB of RAM and I'm having some difficulty getting PostgreSQL to use the available RAM. My RAM settings in postgresql.conf are shared_buffers = ...
    Kevin SchroederKevin Schroeder
    Jan 18, 2005 at 10:49 pm
    Feb 2, 2005 at 3:55 pm
  • Hi all, I've been following this list for nearly a year now. I've always managed to get PostgreSQL 7.1.x right for the job, which in my case is a large and complex oltp system, run under Pg for 6 ...
    Cosimo StrepponeCosimo Streppone
    Jan 31, 2005 at 8:42 pm
    Feb 28, 2005 at 10:15 pm
  • Good morning, I have a table that links two tables and I need to flatten one. (Please, if I'm just not in the good forum for this, tell me. This is a performance issue for me, but you might consider ...
    Alexandre LeclercAlexandre Leclerc
    Jan 27, 2005 at 3:23 pm
    Jan 28, 2005 at 7:59 pm
  • Hi, I have the go ahead of a customer to do some testing on Postgresql in a couple of weeks as a replacement for Oracle. The reason for the test is that the number of users of the warehouse is going ...
    Matt CastersMatt Casters
    Jan 20, 2005 at 9:34 am
    Jan 21, 2005 at 4:06 pm
  • I help manage an animal hospital of 100-employees Linux servers. I am new to database setup and tuning, I was hoping I could get some direction on a setting up drive array we're considering moving ...
    Steve PoeSteve Poe
    Jan 25, 2005 at 8:06 pm
    Feb 1, 2005 at 9:11 pm
  • Hi Folks , I am running this query on postgres 8 beta version and it is not using the right index, where as if i run the same query on postgres 7.4 version it uses the right index . Here are the ...
    Pallav KalvaPallav Kalva
    Jan 28, 2005 at 3:16 pm
    Jan 28, 2005 at 9:57 pm
  • Hi folks, Running on 7.4.2, recently vacuum analysed the three tables in question. The query plan in question changes dramatically when a WHERE clause changes from ports.broken to ports.deprecated. I ...
    Dan LangilleDan Langille
    Jan 20, 2005 at 1:36 am
    Jan 21, 2005 at 12:53 am
  • Hi everyone. I'm new to this forum and was wondering if anyone would be kind enough to help me out with a pretty severe performance issue. I believe the problem to be rather generic, so I'll put it ...
    Ken EgervariKen Egervari
    Jan 27, 2005 at 2:17 am
    Jan 30, 2005 at 5:51 pm
  • Hi, are there any plans for rewriting queries to preexisting materialized views? I mean, rewrite a query (within the optimizer) to use a materialized view instead of the originating table? Regards, ...
    Yann MichelYann Michel
    Jan 3, 2005 at 4:55 pm
    Jan 5, 2005 at 8:12 am
  • Hello everyone, First time poster to the mailing list here. We have been running pgsql for about a year now at a pretty basic level (I guess) as a backend for custom web (intranet) application ...
    SpaceBallOneSpaceBallOne
    Jan 24, 2005 at 7:57 am
    Jan 26, 2005 at 8:00 pm
  • Hi, I have a query which is executed using ilike. The query values are received from user and it is executed using PreparedStatement. Currently all queries are executed as it is using iilike ...
    Antony PaulAntony Paul
    Jan 24, 2005 at 9:18 am
    Jan 25, 2005 at 2:01 pm
  • Wondering ... simply as a tool for easy database building. That is for creating tables that share the same columns but otherwise are unrelated. For example, let's say I have the following set of ...
    KenKen
    Jan 21, 2005 at 8:23 am
    Jan 22, 2005 at 8:22 pm
  • Hi, I have the following problem. A week ago we've migrated from PGv7.2.3 to 7.4.6. There were a lot of things in the apps to chenge but we made them. But one query doesn't want to run. In the old ...
    Kaloyan Iliev IlievKaloyan Iliev Iliev
    Jan 17, 2005 at 3:29 pm
    Jan 18, 2005 at 1:35 pm
  • Hi All, Here is my test comparison between Postgres (7.3.2) optimizer vs Oracle (10g) optimizer. It seems to me that Postgres optimizer is not smart enough. Did I miss anything? Thanks, In Postgres: ...
    Litao WuLitao Wu
    Jan 12, 2005 at 10:25 pm
    Jan 13, 2005 at 3:24 pm
  • I was wondering about index types. Oracle has an index type called a 'bitmap' index. They describe this as an index for low cardinality fields, where only the cardinal values are indexed in a b-tree, ...
    Alex TurnerAlex Turner
    Jan 28, 2005 at 3:40 pm
    Feb 2, 2005 at 11:14 pm
  • Hi i am running a High availability Postgresql server on redhat linux 9. I am using NFS mount of data directory from a shared storage. The server was running without problems for last two months. The ...
    Narayanan Subramaniam IyerNarayanan Subramaniam Iyer
    Jan 29, 2005 at 2:41 pm
    Jan 31, 2005 at 12:52 pm
  • Hi, I noticed that reltuples are way off if I vacuum the table and analyze the table. And the data (296901) after vacuum seems accurate while the reltuples (1.90744e+06) after anlayze is too wrong. ...
    Litao WuLitao Wu
    Jan 24, 2005 at 11:38 pm
    Jan 25, 2005 at 6:48 pm
  • Folks, I'm using PostgreSQL 7.4.1 on Linux, and I'm trying to figure out weather a query I have is going to be slow when I have more information in my tables. both tables involved will likely have ...
    Peter DarleyPeter Darley
    Jan 26, 2005 at 12:19 am
    Jan 31, 2005 at 3:24 pm
  • I'm involved in an implementation of doing trigger-based counting as a substitute for count( * ) in real time in an application. My trigger-based counts seem to be working fine and dramatically ...
    Thomas F.O'ConnellThomas F.O'Connell
    Jan 28, 2005 at 5:22 am
    Jan 28, 2005 at 5:49 pm
  • I'm still relatively new to Postgres. I usually just do SQL programming but have found my self having to administer the DB now. I have I have a problem on my website that when there is high amounts ...
    Ben BostowBen Bostow
    Jan 6, 2005 at 8:03 am
    Jan 6, 2005 at 3:17 pm
  • Does anybody know where I can lay my hands on some guidelines to get best SQL performance out of PostgreSQL? We are about to get into a project that will be new from the ground up (and\we are using ...
    Van Ingen, LaneVan Ingen, Lane
    Jan 26, 2005 at 4:44 pm
    Jan 27, 2005 at 3:20 pm
  • Hi all, We are developing some application that works with DB over JDBC. We've used MSSQL before and trying to migrate to PostgreSQL now. Unfortunately problems with performance are found. MSSQL with ...
    Alexander DolginAlexander Dolgin
    Jan 24, 2005 at 6:28 pm
    Jan 26, 2005 at 9:08 pm
  • I just wanted to bounce off the list the best way to configure disks for a postgresql server. My gut feeling is as follows: Keep the OS and postgresql install on seperate disks to the postgresql ...
    Benjamin WraggBenjamin Wragg
    Jan 18, 2005 at 10:03 pm
    Jan 20, 2005 at 4:06 pm
  • Hi, just want to share with all of you a wierd thing that i found when i tested it. i was doing a query that will call a function long2ip to convert bigint to ips. so the query looks something like ...
    Hasnul Fadhly bin HasanHasnul Fadhly bin Hasan
    Jan 13, 2005 at 8:34 am
    Jan 13, 2005 at 1:45 pm
  • Hi, I am a recent convert to Postgresql, and am trying to tune a very slow query across ten tables all with only a few rows at this stage (<20), and was looking for some help to get me out of a ...
    Guenzl, MartinGuenzl, Martin
    Jan 9, 2005 at 4:44 am
    Jan 9, 2005 at 8:59 am
  • Do large TEXT or VARCHAR entries in postgresql cause any performance degradation when a query is being executed to search for data in a table where the TEXT/VARCHAR fields aren't being searched ...
    Loren M. LangLoren M. Lang
    Jan 8, 2005 at 3:36 am
    Jan 8, 2005 at 5:49 am
  • Summary: Doing a two or three table join for a date range performs worse than doing the same query individually for each date in the range. What works: Doing a query just on a single date or a date ...
    David JaquayDavid Jaquay
    Jan 7, 2005 at 7:18 pm
    Jan 7, 2005 at 8:12 pm
  • Hello, Client is seeing continual performance degradation on updates and queries from a large database. Any help appreciated. Client is using PostgreSQL 7.4.2 on Sparcv9 650MHZ cpu, 2GB Ram, running ...
    Bill ChandlerBill Chandler
    Jan 31, 2005 at 5:20 pm
    Jan 31, 2005 at 6:34 pm
  • Will I have to dump and reload all my databases when migrating from 7.4.2 to 8.0? Jim Gunzelman Senior Software Engineer phone: 402.361.3078 fax: 402.361.3178 e-mail: JamesGunzelmane@Solutionary.com ...
    James GunzelmanJames Gunzelman
    Jan 26, 2005 at 6:51 pm
    Jan 26, 2005 at 8:14 pm
  • I have a query that thinks it's going to generate a huge number of rows, when in fact it won't: INSERT INTO page_log.rrs ( bucket_id, page_id,project_id,other, ...
    Jim C. NasbyJim C. Nasby
    Jan 21, 2005 at 8:39 pm
    Jan 23, 2005 at 10:39 pm
  • Hello everyone, I'm having a problem with some of my tables and I'm not sure if postgres' behaviour is maybe even a bug. I'm (still) using 8.0rc5 at present. I have a table that contains among other ...
    Bernd HellerBernd Heller
    Jan 20, 2005 at 10:14 am
    Jan 21, 2005 at 9:55 am
  • If I have this table, function and index in Postgres 7.3.6 ... """ CREATE TABLE news_stories ( id serial primary key NOT NULL, pub_date timestamp with time zone NOT NULL, ... ) CREATE OR REPLACE ...
    Adrian HolovatyAdrian Holovaty
    Jan 14, 2005 at 6:34 pm
    Jan 17, 2005 at 6:16 pm
  • Hi all, Is there a fast(er) way to get the sum of all integer values for a certain condition over many thousands of rows? What I am currently doing is this (which takes ~5-10sec.): SELECT SUM ...
    Madison KellyMadison Kelly
    Jan 14, 2005 at 3:35 am
    Jan 14, 2005 at 6:34 pm
  • Greetings to one and all, I've been trying to find some information on selecting an optimal filesystem setup for a volume that will only contain a PostgreSQL Database Cluster under Linux. Searching ...
    Pete de ZwartPete de Zwart
    Jan 11, 2005 at 9:24 am
    Jan 14, 2005 at 3:51 pm
  • All of these recent threads about fastest hardware and "who's better than who" has inspired me to create a new website: http://www.dbtuning.org I snipped a few bits from recent posts to get some ...
    Christian FowlerChristian Fowler
    Jan 11, 2005 at 6:05 pm
    Jan 11, 2005 at 9:42 pm
  • Hi there! I'm doing my first tunning on my postgreSQL, my server is for a small app, largest table shall never exceed 10k rows, and less than 1k transactions/day. So I don't think I should run out of ...
    Vinicius Caldeira CarvalhoVinicius Caldeira Carvalho
    Jan 6, 2005 at 1:20 pm
    Jan 6, 2005 at 3:51 pm
  • Hi , I am experiencing a very bad performance on my production database lately , all my queries are slowing down. Our application is a webbased system with lot of selects and updates. I am running ...
    Pallav KalvaPallav Kalva
    Jan 3, 2005 at 10:19 pm
    Jan 4, 2005 at 8:50 pm
  • Hello, if i have the following (simple) table layout: create table a ( id serial primary key ); create table b ( id integer references a, test text ); create view c as select a.id,b.test from a left ...
    Sebastian BöckSebastian Böck
    Jan 27, 2005 at 8:19 am
    Jan 29, 2005 at 12:26 pm
  • Hi gang, I just inherited a FreeBSD box, and it is horribly sick. So we moved everything to a new machine (power supply failures) and finally got stuff running again. Ok, for two days (rimshot) Here ...
    Mitch PirtleMitch Pirtle
    Jan 25, 2005 at 6:19 pm
    Jan 26, 2005 at 7:25 pm
  • My db server is running under high load recently and the number of connections during the morning hours is actually very high. This morning I found the postgres not running and the following in my ...
    Don DrakeDon Drake
    Jan 25, 2005 at 3:13 pm
    Jan 26, 2005 at 4:24 am
  • Hi to all, I have a query which counts how many elements I have in the database. SELECT count(o.id) FROM orders o INNER JOIN report r ON o.id=r.id_order INNER JOIN status s ON o.id_status=s.id INNER ...
    Andrei BintintanAndrei Bintintan
    Jan 17, 2005 at 4:58 pm
    Jan 18, 2005 at 7:49 am
  • Tom, Hmmm ... I'm seeing an issue with IN() optimization -- or rather the lack of it -- in 8.0rc5. It seems to me that this worked better in 7.4, although I've not been able to load this particular ...
    Josh BerkusJosh Berkus
    Jan 15, 2005 at 8:24 pm
    Jan 15, 2005 at 9:33 pm
  • Hi All, I have the following query to generate a report grouped by "states". SELECT distinct upper(cd.state) as mystate, SUM(d.amount) as total_amount, SUM(COALESCE(d.fee,0) + COALESCE(mp.seller_fee, ...
    Sarlav kumarSarlav kumar
    Jan 14, 2005 at 2:39 pm
    Jan 14, 2005 at 3:27 pm
  • I have an integer column that is not needed for some rows in the table (whether it is necessary is a factor of other row attributes, and it isn't worth putting in a separate table). What are the ...
    Jeffrey TennyJeffrey Tenny
    Jan 5, 2005 at 7:09 pm
    Jan 8, 2005 at 9:55 pm
Group Navigation
period‹ prev | Jan 2005 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions65
posts640
users133
websitepostgresql.org
irc#postgresql

133 users for January 2005

Tom Lane: 40 posts Josh Berkus: 33 posts Merlin Moncure: 26 posts Alex Turner: 24 posts Greg Stark: 22 posts Pierre-Frédéric Caillaud: 22 posts Amrit: 19 posts Dave Cramer: 19 posts Joshua D. Drake: 15 posts Richard Huxton: 14 posts Mark Kirkwood: 13 posts Chris Browne: 12 posts Hervé Piedvache: 12 posts Jim C. Nasby: 11 posts William Yu: 11 posts Christopher Kings-Lynne: 10 posts Tatsuo Ishii: 10 posts Kevin Schroeder: 9 posts Alexandre Leclerc: 8 posts Andrew Sullivan: 8 posts
show more
Archives