Good catch Jeff.
as for which version. We always recommend the latest version. 42.1.4
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 29 September 2017 at 06:44, Subramaniam C
wrote:
> Yes you are right the timestamp which the application was providing was in
> seconds where
won't help this situation but there's still no
reason not to upgrade.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 28 September 2017 at 12:32, Subramaniam C
wrote:
> The JDBC version is 9.4-1201-jdbc41.
>
> Query :-
>
> select count(*) OVER() AS count,uuid,a
What version of the driver are you using?
The driver does not automatically use a cursor, but it does use prepared
statements which can be slower.
Can you provide the query and the jdbc query ?
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 28 September 2017 at 05:59
Nobody has asked what kind of machine this is ???
Hard disks, memory, etc.
What are your relevant settings in postgresql.conf ? Shared buffers,
checkpoints, etc.
Also how big are the inserts ? What else is this machine doing ? Is it bare
hardware, or a VM ?
Dave Cramer
dave.cramer(at)credativ
Problem solved... a runaway process (puppet) had consumed all available
real memory
Dave Cramer
On 18 June 2014 15:24, Dave Cramer wrote:
> 2014-06-18 13:37:15 EDT FATAL: could not map anonymous shared memory:
> Cannot allocate memory
> 2014-06-18 13:37:15 EDT HINT: This error usua
45824 bytes), reduce
PostgreSQL's shared memory usage, perhaps by reducing shared_buffers or
max_connections.
ipcs -m
-- Shared Memory Segments
keyshmid owner perms bytes nattch status
Dave Cramer
On 18 June 2014 15:15, Tom Lane wrote:
>
kernel.shmmni = 4096
To reduce the request size [FAILently 2232950784 bytes), reduce
PostgreSQL's shared memory usage,
Dave Cramer
about fragmentation of the WAL logs. I am
looking at testing with and without the WAL logs on ZFS. Any other specific
concerns ?
Dave Cramer
credativ ltd (Canada)
78 Zina St
Orangeville, ON
Canada. L9W 1E8
Office: +1 (905) 766-4091
Mobile: +1 (519) 939-0336
Tom,
Will try to get one ASAP.
Dave
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Nov 12, 2012 at 3:43 PM, Tom Lane wrote:
> Dave Cramer writes:
> > This query is a couple orders of magnitude slower the first result is
> > 9.2.1, the second
note_sets (cost=0.00..398.00 rows=199 width=8)
(actual time=0.216..0.244 rows=1 loops=46)
Index Cond: (parent_id
= parent_noteset.id)
-> Index Scan using note_sets_pkey on note_sets
(cost=0.00..9.67 rows=1 width=40) (actual time=0.234..0.234 rows=1
loops=46)
Index Cond: (id = parent_noteset.id)
-> Hash (cost=1.16..1.16 rows=16 width=794) (actual time=0.020..0.020
rows=16 loops=1)
Buckets: 1024 Batches: 1 Memory Usage: 2kB
-> Seq Scan on note_set_sources (cost=0.00..1.16 rows=16
width=794) (actual time=0.012..0.014 rows=16 loops=1)
Total runtime: 829.657 ms
(25 rows)
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Thu, Aug 30, 2012 at 2:34 AM, Eileen wrote:
> Hi,
>
> I have written some Java code which builds a postgresql function. That
> function calls approximately 6 INSERT statements with a RETURNING clause. I
>
On Wed, Apr 14, 2010 at 7:10 PM, Craig Ringer
wrote:
> On 15/04/10 04:49, Dave Crooke wrote:
>>
>> Hi foilks
>>
>> I am using PG 8.3 from Java. I am considering a performance tweak which
>> will involve holding about 150 java.sql.PreparedStatment objects open
>> against a single PGSQL connection.
You should also keep in mind that JDBC uses prepared statements, so you have
to explain analyze accordingly.
Dave
On Thu, Oct 8, 2009 at 5:18 PM, Tom Lane wrote:
> G B writes:
> > How can explain-analyze return significantly much faster than other
> means?
>
> If the returned data is large or
On Fri, Mar 27, 2009 at 4:33 PM, David Rees wrote:
> On Fri, Mar 27, 2009 at 10:30 AM, wrote:
> > On Thu, 26 Mar 2009, Dave Cramer wrote:
> >> So far using dd I am seeing around 264MB/s on ext3, 335MB/s on ext2
> write
> >> speed. So the question becomes what i
So far using dd I am seeing around 264MB/s on ext3, 335MB/s on ext2 write
speed. So the question becomes what is the best filesystem for this drive?
Anyone want me to run anything on it ?
Dave
On Mon, Mar 9, 2009 at 1:16 PM, Tom Lane wrote:
> Guillaume Smet writes:
> > Unnamed prepared statements are planned after binding the values,
> > starting with 8.3, or more precisely starting with 8.3.2 as early 8.3
> > versions were partially broken on this behalf.
>
> No, 8.2 did it too (othe
Any idea why it wouldn't choose the right index ?
This is 8.3
# \d battles
Table "public.battles"
Column|Type |
Modifiers
-+-
+
I have a query which is
prepare s_18 as select uid from user_profile where name like
$1::varchar and isactive=$2 order by name asc limit 250;
explain analyze execute s_18 ('atxchery%','t');
QUERY
PLAN
--
On 17-Mar-08, at 2:50 PM, Justin wrote:
Just out of curiosity: Last time I did research, the word seemed to
be that xfs was better than ext2 or ext3. Is that not true? Why
use ext2/3 at all if xfs is faster for Postgres?
Criag
Ext2 vs XFS on my setup there is difference in the perf
On 16-Mar-08, at 3:04 PM, Craig James wrote:
Dave Cramer wrote:
On 16-Mar-08, at 2:19 AM, Justin wrote:
I decided to reformat the raid 10 into ext2 to see if there was
any real big difference in performance as some people have noted
here is the test results
please note the WAL files
On 16-Mar-08, at 2:19 AM, Justin wrote:
I decided to reformat the raid 10 into ext2 to see if there was any
real big difference in performance as some people have noted here
is the test results
please note the WAL files are still on the raid 0 set which is still
in ext3 file system f
On 11-Mar-08, at 8:28 AM, petchimuthu lingam wrote:
I have one table with 30 fields, i have more then 60 million
records, if i use more no of indexes will it affect the insertion
performance? and select performance?
Yes, and yes, but without more information about what you are trying
to do
On 6-Mar-08, at 9:30 PM, Stephen Denne wrote:
The strange thing of course is that the data is exactly the same for
both runs, the tables have not been changed between runs, and I did
them right after another. Even more strange is that the seq scan is
faster than the index scan.
It is not stra
Josh,
On 6-Mar-08, at 12:26 PM, Josh Berkus wrote:
Dave,
Below I have two almost identical queries. Strangely enough the one
that uses the index is slower ???
My first guess would be that records are highly correlated by DOB
and not at
all by name. However, it would help if you supplie
On 6-Mar-08, at 5:10 PM, Stephen Denne wrote:
Dave Cramer wrote:
I have two almost identical queries. Strangely enough the one
that uses the index is slower ???
The index scan is being used so that it can retrieve the rows in the
name order.
It expects that if it was to retrieve every
On 6-Mar-08, at 12:26 PM, Josh Berkus wrote:
Dave,
Below I have two almost identical queries. Strangely enough the one
that uses the index is slower ???
My first guess would be that records are highly correlated by DOB
and not at
all by name. However, it would help if you supplied both
Hi,
On 6-Mar-08, at 6:58 AM, sathiya psql wrote:
The only thing that is going to help you is really fast disks, and
more memory, and you should consider moving to 8.3 for all the other
performance benefits.
Is 8.3 is a stable version or what is the latest stable version of
postgres ??
Yes
On 6-Mar-08, at 1:43 AM, sathiya psql wrote:
is there any way to explicitly force the postgres to use index scan
If you want to count all the rows in the table there is only one way
to do it (without keeping track yourself with a trigger ); a seq scan.
An index will not help you.
The o
Below I have two almost identical queries. Strangely enough the one
that uses the index is slower ???
explain analyze select uid from user_profile where
lower(firstname)='angie' and extract(year from age('2008-02-26
02:50:31.382', dob)) >= 18 and extract(year from age('2008-02-26
02:50:3
Hi,
I've run it on xen. works OK. Course this is all predicated upon your
expectations. If you expect it to be as fast as a dedicated machine,
you will be dissapointed.
Dave
On 5-Mar-08, at 3:54 AM, Moritz Onken wrote:
We have very good experiences with openVZ as virtualizer.
Since it's n
On 21-Feb-08, at 6:16 PM, Scott Marlowe wrote:
On Thu, Feb 21, 2008 at 4:59 PM, Mark Kirkwood
<[EMAIL PROTECTED]> wrote:
The other parameter you might want to look at is
effective_cache_size -
increasing it will encourage index use. On a machine with 16GB the
default is probably too small (
On 21-Feb-08, at 12:13 AM, bh yuan wrote:
Hi
I am using Postgres8.3 on 8G memory , Xeon X5355 Quad Core x 2
processer RH5 machine with 10G data. (with some table which have
about 2,000,000~ 5,000,000 rows )
I have two quesion.
1. how to set the shared_buffers and other postgresql.conf parame
On 19-Feb-08, at 2:35 PM, Douglas J Hunley wrote:
On Tuesday 19 February 2008 14:28:54 Dave Cramer wrote:
shared buffers is *way* too small as is effective cache
set them to 2G/6G respectively.
Dave
pardon my ignorance, but is this in the context of a restore only?
or 'in
ge
shared buffers is *way* too small as is effective cache
set them to 2G/6G respectively.
Dave
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On 19-Feb-08, at 1:12 PM, Joshua D. Drake wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 19 Feb 2008 13:03:58 -0500
Douglas J Hunley <[EMAIL PROTECTED]> wrote:
I spent a whopping seven hours restoring a database late Fri nite for
a client. We stopped the application, ran pg_dum
On 17-Feb-08, at 10:18 AM, Bill Moran wrote:
"Mohamed Ali JBELI" <[EMAIL PROTECTED]> wrote:
Hi members
I am looking for an example of a web application (WAR) which
executea a
Postgres actions. This aims to test the performance of Postgres in
Web mode.
I shall be grateful if someone giv
On 13-Feb-08, at 5:02 AM, Tore Halset wrote:
Hello.
I think I started that discussion. We ended up buying a Dell 2900
with PERC 6/i and 10 * 145GB SAS 3,5" 15KRpm discs. 6 of the SAS
discs are in a raid 10 for the database, 2 in a mirror for the wal
and the last 2 in a mirror for the OS.
On 12-Nov-07, at 11:37 AM, Tom Lane wrote:
Alvaro Herrera <[EMAIL PROTECTED]> writes:
Well, AFAIK the index with varchar_pattern_ops is used for LIKE
queries,
whereas the other one is going to be used for = queries. So you
need to
keep both indexes.
Given the current definition of text
On 12-Nov-07, at 9:56 AM, Alvaro Herrera wrote:
Dave Cramer wrote:
In order to get like queries to use an index with database
initialized with
a UTF-8 character set I added a unique index to a table with a
varchar_pattern_ops
This table already had a unique constraint on the column so I
In order to get like queries to use an index with database initialized
with a UTF-8 character set I added a unique index to a table with a
varchar_pattern_ops
This table already had a unique constraint on the column so I dropped
the unique constraint.
I can't give exact measurements howev
hubert depesz lubaczewski wrote:
On Tue, Sep 25, 2007 at 07:08:42AM -0400, Dave Cramer wrote:
ERROR: deadlock detected
DETAIL: Process 23063 waits for ExclusiveLock on tuple (20502,48) of
relation 48999028 of database 14510214; blocked by process 23110.
Process 23110 waits for ShareLock
I have a database that we want to keep track of counts of rows.
We have triggers on the rows which increment, and decrement a count
table. In order to speed up deleting many rows we have added the following
if user != 'mocospace_cleanup'
then
On 13-Aug-07, at 9:50 AM, Vivek Khera wrote:
On Aug 10, 2007, at 4:36 PM, Merlin Moncure wrote:
I'm not so sure I agree. They are using LSI firmware now (and so is
everyone else). The servers are well built (highly subjective, I
admit) and configurable. I have had some bad experiences wit
On 11-Jul-07, at 2:35 PM, Greg Smith wrote:
On Wed, 11 Jul 2007, Jim Nasby wrote:
I suppose an entirely in-memory database might be able to swamp a
2 drive WAL as well.
You can really generate a whole lot of WAL volume on an EMC SAN if
you're doing UPDATEs fast enough on data that is mos
On 11-Jul-07, at 10:05 AM, Gregory Stark wrote:
"Dave Cramer" <[EMAIL PROTECTED]> writes:
Assuming we have 24 73G drives is it better to make one big
metalun and carve
it up and let the SAN manage the where everything is, or is it
better to
specify which spindles are
Assuming we have 24 73G drives is it better to make one big metalun
and carve it up and let the SAN manage the where everything is, or is
it better to specify which spindles are where.
Currently we would require 3 separate disk arrays.
one for the main database, second one for WAL logs, thir
Hi Andrew
On 11-Jun-07, at 11:34 AM, Andrew Sullivan wrote:
On Mon, Jun 11, 2007 at 11:09:42AM -0400, Dave Cramer wrote:
and set them to anything remotely close to 128GB.
Well, we'd give 25% of it to postgres, and the rest to the OS.
Are you quite sure that PostgreSQL's managem
Hi Andrew
On 11-Jun-07, at 11:34 AM, Andrew Sullivan wrote:
On Mon, Jun 11, 2007 at 11:09:42AM -0400, Dave Cramer wrote:
and set them to anything remotely close to 128GB.
Well, we'd give 25% of it to postgres, and the rest to the OS.
Are you quite sure that PostgreSQL's managem
On 10-Jun-07, at 11:11 PM, Jim Nasby wrote:
On Jun 8, 2007, at 11:31 AM, Dave Cramer wrote:
Is it possible that providing 128G of ram is too much ? Will other
systems in the server bottleneck ?
Providing to what? PostgreSQL? The OS? My bet is that you'll run
into issues wit
Actually this one is an opteron, so it looks like it's all good.
Dave
On 8-Jun-07, at 3:41 PM, Guy Rouillier wrote:
Dave Cramer wrote:
It's an IBM x3850 using linux redhat 4.0
I had to look that up, web site says it is a 4-processor, dual-core
(so 8 cores) Intel Xeon system. It
On 8-Jun-07, at 2:10 PM, Joshua D. Drake wrote:
Zoltan Boszormenyi wrote:
Dave Cramer írta:
It's an IBM x3850 using linux redhat 4.0
Isn't that a bit old? I have a RedHat 4.2 somewhere
that was bundled with Applixware 3. :-)
He means redhat ES/AS 4 I assume.
It's an IBM x3850 using linux redhat 4.0
On 8-Jun-07, at 12:46 PM, Guy Rouillier wrote:
Dave Cramer wrote:
Is it possible that providing 128G of ram is too much ? Will other
systems in the server bottleneck ?
What CPU and OS are you considering?
--
Guy Roui
Is it possible that providing 128G of ram is too much ? Will other
systems in the server bottleneck ?
Dave
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Does anyone have any experience running pg on multiple IBM 3950's set
up as a single machine ?
Dave
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED]
Heikki,
Don't the archived logs have to be copied as well as the regular WAL
logs get recycled ?
Dave
On 28-May-07, at 12:31 PM, Heikki Linnakangas wrote:
Dave Cramer wrote:
Since PITR has to enable archiving does this not increase the
amount of disk I/O required ?
There
Since PITR has to enable archiving does this not increase the amount
of disk I/O required ?
Dave
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
* set reasonable statement timeout
* backup with pitr. pg_dump is a headache on extremely busy servers.
Where do you put your pitr wal logs so that they don't take up extra
I/O ?
* get good i/o system for your box. start with 6 disk raid 10 and go
from there.
* spend some time reading about
On 2-May-07, at 11:24 AM, Parks, Aaron B. wrote:
My pg 8.1 install on an AMD-64 box (4 processors) with 9 gigs of
ram running RHEL4 is acting kind of odd and I thought I would see
if anybody has any hints.
I have Java program using postgresql-8.1-409.jdbc3.jar to connect
over the netwo
On 25-Apr-07, at 4:54 AM, Heikki Linnakangas wrote:
Paweł Gruszczyński wrote:
To test I use pgBench with default database schema, run for 25,
50, 75 users at one time. Every test I run 5 time to take average.
Unfortunetly my result shows that ext is fastest, ext3 and jfs are
very simillar.
Hi Csaba,
I have a similar problem.
In an attempt to avoid the overhead of select count(*) from mailbox
where uid = somuid I've implemented triggers on insert and delete.
So there is a
user table which refers to to an inbox table,
so when people insert into the inbox there is an RI trigger
TECTED] On Behalf Of Dave
Cramer
Sent: Thursday, April 05, 2007 4:01 PM
To: John Allgood
Cc: 'Jeff Frost'; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] High Load on Postgres 7.4.16 Server
On 5-Apr-07, at 3:33 PM, John Allgood wrote:
The hard thing about running multiple pos
On 5-Apr-07, at 3:33 PM, John Allgood wrote:
The hard thing about running multiple postmasters is that you have
to tune
each one separate. Most of the databases I have limited the max-
connections
to 30-50 depending on the database. What would reasonable values for
effective_cache_size and r
On 4-Apr-07, at 2:01 AM, Peter Schuller wrote:
Hello,
The next question then is whether anything in your postgres
configuration
is preventing it getting useful performance from the OS. What
settings
have you changed in postgresql.conf?
The only options not commented out are the followin
I may have missed this but have you tuned your postgresql
configuration ?
8.2 tuning guidelines are significantly different than 7.3
Dave
On 1-Apr-07, at 1:51 PM, Xiaoning Ding wrote:
I repeated the test again. It took 0.92 second under 8.2.3.
I checked system load using top and ps. There i
I also think there have been changes in pgbench itself.
Make sure you run the same pgbench on both servers.
Dave
On 24-Mar-07, at 6:44 AM, Heikki Linnakangas wrote:
amrit angsusingh wrote:
I try to change my database server from the older one ie. 2Cpu
Xeon 2.4 32
bit 4Gb SDram Hdd SCSI RAID
On 20-Mar-07, at 1:53 PM, Benjamin Arai wrote:
This is a little biased but I would stay away from areca only
because they have fans on the card. At some point down the line
that card is going to die. When it does there is really no telling
what it will do to your data. I personally use
On 20-Mar-07, at 9:23 AM, Ireneusz Pluta wrote:
Hello all,
I sent a similar post to a FreeBSD group, but thought I'd might try
here too.
I am completing a box for PostgreSQL server on FreeBSD. Selecting a
RAID controller I decided to go with 3ware SE9650-16, following
good opinions abo
On 26-Feb-07, at 11:12 AM, Gene wrote:
hi!
I've been having some serious performance issues with
postgresql8.2/hibernate/jdbc due to postgres reusing bad cached query
plans. It doesn't look at the parameter values and therefore does not
use any partial indexes.
After trying to set prepareThre
On 26-Jan-07, at 6:28 AM, John Parnefjord wrote:
Hi!
I'm planning to move from mysql to postgresql as I believe the latter
performs better when it comes to complex queries. The mysql database
that I'm running is about 150 GB in size, with 300 million rows in the
largest table. We do quite a l
On 17-Jan-07, at 3:41 PM, Steve wrote:
Hey there;
I've been lurking on this list awhile, and I've been working with
postgres for a number of years so I'm not exactly new to this. But
I'm still having trouble getting a good balance of settings and I'd
like to see what other people think.
On 17-Jan-07, at 9:37 AM, Jeremy Haile wrote:
I still keep wondering if this table is bloated with dead tuples.
Even
if you vacuum often if there's a connection with an idle transaction,
the tuples can't be reclaimed and the table would continue to grow.
I used to vacuum once an hour, alth
On 14-Jan-07, at 10:34 AM, Rolf Østvik (HA/EXA) wrote:
Computer:
Dell PowerEdge 2950
openSUSE Linux 10.1
Intel(R) Xeon 3.00GHz
4GB memory
xfs filesystem on SAS disks
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
On 14-Jan-07, at 7:31 AM, Rolf Østvik (HA/EXA) wrote:
1234567890123456789012345678901234567890123456789012345678901234567890
1234567890
00112233445566
77
I have been trying to change a many parameters on server versions
7.4.15, 8
On 13-Jan-07, at 7:24 PM, Tom Lane wrote:
Jignesh Shah <[EMAIL PROTECTED]> writes:
The appserver is basically using bunch of prepared statements that
the
server should be executing directly without doing the parsing again.
Better have another look at that theory, because you're clearly
s
On 12-Jan-07, at 7:31 PM, Mark Dobbrow wrote:
Hello -
I have a fairly large table (3 million records), and am fetching
10,000 non-contigous records doing a simple select on an indexed
column ie
select grades from large_table where teacher_id = X
This is a test database, so the number of
On 9-Jan-07, at 7:50 AM, Nörder-Tuitje, Marcus wrote:
Forget abount "IN". Its horribly slow.
I think that statement above was historically correct, but is now
incorrect. IN has been optimized quite significantly since 7.4
Dave
try :
select w.appid,
w.rate,
w.is_subscribe
On 6-Jan-07, at 11:32 PM, Guy Rouillier wrote:
Dave Cramer wrote:
The box has 3 GB of memory. I would think that BigDBMS would be
hurt by this more than PG. Here are the settings I've modified
in postgresql.conf:
As I said you need to set shared_buffers to at least 750MB this is
On 5-Jan-07, at 9:51 PM, Guy Rouillier wrote:
I've got back access to my test system. I ran another test run
with the same input data set. This time I put pg_xlog on a
different RAID volume (the unused one that I suspect is a software
RAID), and I turned fsync=off in postgresql.conf. I
On 31-Dec-06, at 6:33 AM, Rolf Østvik wrote:
Hi
I have a simple query which uses 32ms on 7.4.14 and 1015ms on 8.2.0.
I guess 7.4.14 creates a better execution plan than 8.2.0 for this
query but
i don't know how to get it to select a better one.
Explain analyse output will be found near the
Hi,
On 28-Dec-06, at 8:58 PM, fabrix peñuelas wrote:
Good day,
I have been reading about the configuration of postgresql, but I
have a server who does not give me the performance that should. The
tables are indexed and made vacuum regularly, i monitor with top,
ps and pg_stat_activity an
Guy,
Did you tune postgresql ? How much memory does the box have? Have you
tuned postgresql ?
Dave
On 28-Dec-06, at 12:46 AM, Guy Rouillier wrote:
I don't want to violate any license agreement by discussing
performance, so I'll refer to a large, commercial PostgreSQL-
compatible DBMS only
On 11-Dec-06, at 5:36 AM, Daniel van Ham Colchete wrote:
Hi Dave,
On 12/11/06, Dave Cramer <[EMAIL PROTECTED]> wrote:
Hi Daniel
On 10-Dec-06, at 8:02 PM, Daniel van Ham Colchete wrote:
> Hi Gene,
>
> at my postgresql.conf, the only non-comented lines are:
> fsync = off
On 6-Dec-06, at 8:20 AM, Jens Schipkowski wrote:
On Wed, 06 Dec 2006 13:29:37 +0100, Dave Cramer <[EMAIL PROTECTED]>
wrote:
Unless you specifically ask for it postgresql doesn't lock any
rows when you update data.
Thats not right. UPDATE will force a RowExclusiveLock to rows
Unless you specifically ask for it postgresql doesn't lock any rows
when you update data.
Dave
On 6-Dec-06, at 2:04 AM, Joost Kraaijeveld wrote:
Does PostgreSQL lock the entire row in a table if I update only 1
column?
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nij
On 4-Dec-06, at 12:10 PM, Mark Lonsdale wrote:
Hi
We are migrating our Postgres 7.3.4 application to postgres 8.1.5
and also moving it to a server with a much larger hardware
configuration as well.The server will have the following
specification.
- 4 physical CPUs (hypert
Brian,
On 16-Nov-06, at 7:03 PM, Brian Wipf wrote:
I'm trying to optimize a PostgreSQL 8.1.5 database running on an
Apple G5 Xserve (dual G5 2.3 GHz w/ 8GB of RAM), running Mac OS X
10.4.8 Server.
The queries on the database are mostly reads, and I know a larger
shared memory allocation w
On 17-Oct-06, at 3:05 PM, Behl, Rohit ((Infosys)) wrote: HiWe are facing performance problems in postgres while executing a query. When I execute this query on the server it takes 5-10 seconds. Also I get good performance while executing this query from my code in java with the hard codes values.
Ben,
On 20-Oct-06, at 3:49 AM, Ben Suffolk wrote:
Hello all,
I am currently working out the best type of machine for a high
volume pgsql database that I going to need for a project. I will be
purchasing a new server specifically for the database, and it won't
be running any other applica
On 23-Sep-06, at 9:49 AM, Guido Neitzer wrote:
On 9/23/06, Dave Cramer <[EMAIL PROTECTED]> wrote:
1) The database fits entirely in memory, so this is really only
testing CPU, not I/O which should be taken into account IMO
I don't think this really is a reason that MySQL broke
On 23-Sep-06, at 9:00 AM, Guido Neitzer wrote:
I find the benchmark much more interesting in comparing PostgreSQL to
MySQL than Intel to AMD. It might be as biased as other "benchmarks"
but it shows clearly something that a lot of PostgreSQL user always
thought: MySQL gives up on concurrency ..
On 14-Sep-06, at 7:50 PM, Francisco Reyes wrote:
Dave Cramer writes:
personally, I'd set this to about 6G. This doesn't actually
consume memory it is just a setting to tell postgresql how much
memory is being used for cache and kernel buffers
Gotcha. Will increase further.
Francisco
On 14-Sep-06, at 4:30 PM, Francisco Reyes wrote:
Dave Cramer writes:
What is a reasonable number?
I estimate I have at least 1 to 2 GB free of memory.
You are using 6G of memory for something else ?
Right now adding up from ps the memory I have about 2GB.
Have an occassional
Francisco
On 14-Sep-06, at 1:36 PM, Francisco Reyes wrote:
Dave Cramer writes:
What is effective_cache set to ?
Increasing this seems to have helped significantly a web app. Load
times seem magnitudes faster.
Increased it to effective_cache_size = 12288 # 96MB
What is a reasonable
On 14-Sep-06, at 11:23 AM, Francisco Reyes wrote:
My setup:
Freebsd 6.1
Postgresql 8.1.4
Memory: 8GB
SATA Disks
Raid 1 10 spindles (2 as hot spares)
500GB disks (16MB buffer), 7200 rpm
Raid 10
Raid 2 4 spindles
150GB 10K rpm disks
Raid 10
shared_buffers = 1
shared buffers should be consi
Have you tuned postgresql ?
You still haven't told us what the machine is, or the tuning
parameters. If you follow Merlin's links you will find his properly
tuned postgres out performs mysql in every case.
--dc--
On 14-Sep-06, at 2:55 AM, yoav x wrote:
You can use the test with InnoDB by g
AM, yoav x wrote:
So why are these queries so slow in PG?
--- Dave Cramer <[EMAIL PROTECTED]> wrote:
All of the tuning parameters would affect all queries
shared buffers, wal buffers, effective cache, to name a few
--dc--
On 13-Sep-06, at 8:24 AM, yoav x wrote:
Hi
I am trying to run s
All of the tuning parameters would affect all queries
shared buffers, wal buffers, effective cache, to name a few
--dc--
On 13-Sep-06, at 8:24 AM, yoav x wrote:
Hi
I am trying to run sql-bench against PostgreSQL 8.1.4 on Linux.
Some of the insert tests seems to be ver slow
For example: selec
On 13-Sep-06, at 6:16 AM, Laszlo Nagy wrote:
I have had extremely bad performance historically with onboard
SATA chipsets
on Linux. The one exception has been with the Intel based
chipsets (not the
CPU, the I/O chipset).
This board has Intel chipset. I cannot remember the exact type but
On 8-Sep-06, at 8:44 AM, Arjen van der Meijden wrote:
Dave Cramer wrote:
Hi, Arjen,
The Woodcrest is quite a bit faster than the Opterons.
Actually... With Hyperthreading *enabled* the older Dempsey-
processor is also faster than the Opterons with PostgreSQL. But
then again, it is the
Hi, Arjen,
On 8-Sep-06, at 1:51 AM, Arjen van der Meijden wrote:
Hi,
We've been running our "webapp database"-benchmark again on mysql
and postgresql. This time using a Fujitsu-Siemens RX300 S3 machine
equipped with a 2.66Ghz Woodcrest (5150) and a 3.73Ghz Dempsey
(5080). And compared t
1 - 100 of 192 matches
Mail list logo
