Hi,
I am trying to tune a query that is taking too much time on a large
dataset (postgres 8.3).
SELECT DISTINCT
role_user.project_id AS projectId,
sfuser.username AS adminUsername,
sfuser.full_name AS adminFullName
FROM
role_operation role_operation,
ro
http%3A%2F%2Fwww%2Eproductionsoundmixer%2Eorg%2Fimages%2Famw%2Ephp
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Achilleas Mantzios wrote:
How are you gonna show up in the FreeBSD-* mailing list when you are still on
6.2?
Psst! - I came just here. Don't tell them.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.or
On Thu, Mar 31, 2011 at 12:26 PM, Laszlo Nagy wrote:
> For this query:
>
> select pp.id,pp.product_id,pp.selling_site_id,pp.asin
> from product_price pp
> where
> (pp.asin is not null and pp.asin<>'')
> and (pp.upload_status_id<>1)
> and pp.selling_site_id in (8,7,35,6,9)
> and (pp.last_od < 'now'
Database Test Suite
H o w are you all ??
I am new in this group.
I have windows 7 as OS and i installed postgresql 9.0 i want
a to do some tests so i need bench mark to test some workloads?
i need the same as Database Test Suite
http://sourceforge.net/projects/osdldbt/
but for windows can any one
Friday, April 8, 2011, 1:52:03 PM you wrote:
> Scott Marlowe wrote:
>> If I may ask, how often does it crash? And have you tried updating
>> the firmware of the controller and / or the driver in the OS?
>>
> It happens once per two or three months, or so, taking the average. The
> firmware is bet
Στις Friday 08 April 2011 14:53:58 ο/η Ireneusz Pluta έγραψε:
>
> My general plan for now is to migrate all services from this machine to the
> new ones and refresh it
> completely for use with less critical services. But it is not a task for just
> a few days so the
That's a pain. Migrating
Scott Marlowe wrote:
If I may ask, how often does it crash? And have you tried updating
the firmware of the controller and / or the driver in the OS?
It happens once per two or three months, or so, taking the average. The firmware is beta as of
January this year, advised to use by their technic
Scott Marlowe wrote:
If I may ask, how often does it crash? And have you tried updating
the firmware of the controller and / or the driver in the OS?
It happens once per two or three months, or so, taking the average. The firmware is beta as of
January this year, advised to use by their technic
On 08/04/2011 07:55, Ireneusz Pluta wrote:
Achilleas Mantzios wrote:
In anyway, having FreeBSD to fsck, (background or not) should not
happen. And the problem
becomes bigger when cheap SATA drives will cheat about their write
cache being flushed to the disk.
So in the common case with cheap har
Greg Smith wrote:
The soft update code used in FreeBSD makes sure that there's no damage to the filesystem that
PostgreSQL can't recover from. Once the WAL is replayed after a crash, the database is
consistent. The main purpose of the background fsck is to find "orphaned" space, things that th
11 matches
Mail list logo