Hi there!
We currently have a database table that's laid out something like this:
id int
date1 date
belongs_to date
type varchar(1)
type_fk int
start_time time
end_time time
location_fk int
department_fk int
value decimal
Where each row represents some data throughout the day
On Sat, Oct 22, 2011 at 10:58 AM, Tom Lane wrote:
> Anthony Presley writes:
> > We have a dev machine running 9.0.1 (an i3 laptop, with a regular hard
> disk,
> > with 4GB of RAM, and a mostly untuned postgresql.conf file). The changed
> > lines are:
>
Hi there!
We have a dev machine running 9.0.1 (an i3 laptop, with a regular hard disk,
with 4GB of RAM, and a mostly untuned postgresql.conf file). The changed
lines are:
shared_buffers = 512MB
temp_buffers = 48MB
work_mem = 32MB
maintenance_work_mem = 348MB
checkpoint_segments = 10
e
On Tue, Sep 13, 2011 at 1:22 AM, Arjen van der Meijden <
acmmail...@tweakers.net> wrote:
>
> On 12-9-2011 0:44 Anthony Presley wrote:
>
>> A few weeks back, we purchased two refurb'd HP DL360's G5's, and were
>> hoping to set them up with PG 9.0.2, runn
checkpoint_segments = 30 (have tried 200 when I was loading the db)
random_page_cost = 2.5
effective_cache_size = 10240MB (have tried as high as 16GB)
If I disable the hashjoin, I get massive improvements on PG 9.x ... as fast
(or faster) than our PG 8.4 instance.
--
Anthony Presley
You may want to try pgreplay ... we've tried it for a similar scenario, and
so far, it's pretty promising.
I do wish it was able to be loaded from a pgfouine formatted log file, or
from another db ... but that's OK.
--
Anthony Presley
On Mon, Sep 12, 2011 at 6:28 PM, Hany ABO
cached.
Both of these servers have the same indexes, and almost identical data.
However, the old server is doing some different planning than the new
server.
What did I switch (or should I unswitch)?
--
Anthony
On Sun, Sep 11, 2011 at 9:12 PM, Alan Hodgson wrote:
> On September 11, 2011 03:4
Mark,
On Sun, Sep 11, 2011 at 10:10 PM, mark wrote:
>
>
> >From: pgsql-performance-ow...@postgresql.org
> [mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of Anthony
> Presley
> >Sent: Sunday, September 11, 2011 4:45 PM
> >To: pgsql-performance@postgresql.
On Sun, Sep 11, 2011 at 6:17 PM, Tomas Vondra wrote:
> Dne 12.9.2011 00:44, Anthony Presley napsal(a):
> > We've currently got PG 8.4.4 running on a whitebox hardware set up,
> > with (2) 5410 Xeon's, and 16GB of RAM. It's also got (4) 7200RPM
> > SATA driv
We've currently got PG 8.4.4 running on a whitebox hardware set up, with (2)
5410 Xeon's, and 16GB of RAM. It's also got (4) 7200RPM SATA drives, using
the onboard IDE controller and ext3.
A few weeks back, we purchased two refurb'd HP DL360's G5's, and were hoping
to set them up with PG 9.0.2, r
and you have to buy their
version of the software to use?
I'm fine with piecing together a few different OS projects, but would prefer
to not modify the app too much.
Thanks!
--
Anthony Presley
On Tue, 2009-10-06 at 17:16 -0400, Merlin Moncure wrote:
> On Sun, Oct 4, 2009 at 6:45 PM, wrote:
> > All:
> >
> > We have a web-application which is growing ... fast. We're currently
> > running on (1) quad-core Xeon 2.0Ghz with a RAID-1 setup, and 8GB of RAM.
> >
> > Our application collects a
ombinations in under 1 or
2 seconds.
(Of course, you still need to store the results, and feed the input,
using a database of some kind).
--
Anthony Presley
On Tue, 2009-06-16 at 14:35 -0400, Hartman, Matthew wrote:
> Good afternoon.
>
> I have developed an application to efficiently s
Hmm ... I'm guessing you'd do it with a shortcut, and then rename the
ShortCut from "Shortcut to pg_xlog" to "pg_xlog".
Haven't done it with PostgreSQL, but it works with a few other programs
I've had to do that with.
--
Anthony Presley
Resolution Softw
to be a bother!
--
Anthony
On Fri, 2006-09-22 at 18:58 -0500, Anthony Presley wrote:
> I thought this was related to the TYPE (ie, I could cast it using
> something like: attr1=1::int8). However, I tried a few more values, and
> the query planner is confusing me.
>
> With these
ng
of a 'black box' application.
Thoughts?
--
Anthony
On Fri, 2006-09-22 at 17:59 -0500, Anthony Presley wrote:
> Hi all, I'm having some confusion with the 7.4 query planner.
>
> I have two identical queries, whereby the passed (varchar) parameter
> appears to b
Hi all, I'm having some confusion with the 7.4 query planner.
I have two identical queries, whereby the passed (varchar) parameter
appears to be the deciding factor between a sequential or an index scan.
IE, This query:
explain SELECT DISTINCT (a1.ENTRY_ID) AS retrieved FROM OS_CURRENTSTEP
AS a
Hi all!
I had an interesting discussion today w/ an Enterprise DB developer and
sales person, and was told, twice, that the 64-bit linux version of
Enterprise DB (which is based on the 64-bit version of PostgreSQL 8.1)
is SIGNIFICANTLY SLOWER than the 32-bit version. Since the guys of EDB
are Pos
18 matches
Mail list logo
