or 7 queries per request. So I'm fine for a
while.
You can see for yourself if you enter the demo account for the site in my sig,
and click in a couple of files (it's the database that gets re-created by the
procedure I mentionned in my original post)
--
plifying errors on the discs.
Now on to decide whether I'm waiting for the fix or re-building a new box...
Thanks a bunch for your help.
--
Bien à vous, Vincent Veyron
https://libremen.com
Logiciels de gestion, libres
--
Sent via pgsql-performa
tabases.
I've put in a ticket at the Online provider with the data to see if they have
an answer (now 14H00 in Paris, so they may take a while to respond)
--
Bien à vous, Vincent Veyron
https://compta.libremen.com
Logiciel libre de comptabilit
Number:
Rank: 1
Configured Clock Speed: 1333 MHz
Minimum voltage: Unknown
Maximum voltage: Unknown
Configured voltage: Unknown
--
Bien à vous, Vincent Veyron
https://libremen.com
Logiciels de gestion, libres
re regular queries much faster on this same server?
--
Bien à vous, Vincent Veyron
https://legalcase.libremen.com/
Legal case management software
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Op 7/8/2016 om 12:23 PM schreef Jean-David Beyer:
Why all this concern about how long a disk (or SSD) drive can stay up
after a power failure?
It seems to me that anyone interested in maintaining an important
database would have suitable backup power on their entire systems,
including the disk
more ideas.
thank you for your help.
Mathieu VINCENT
2015-12-17 11:58 GMT+01:00 Mathieu VINCENT :
> Adding foreign key between on t2 and t3, does not change the plan.
>
> drop table if exists t1;
> drop table if exists t2;
> drop table if exists t3;
>
> create table t1
verbose t2;
analyze verbose t3;
EXPLAIN (analyze on, buffers on, verbose on)
select
*
from
t1 t1
inner join t2 on t1.c1=t2.c1
inner join t3 on t1.c1=t3.c1
Cordialement,
<http://www.psih.fr/>PSIH Décisionnel en santé
Mathieu VINCENT
Data Analyst
PMSIpilot - 61 rue Sully - 69006 Lyon - France
2
inner join t2 on t1.c1=t2.c1
inner join t3 on t2.c1=t3.c1
the explain plan : http://explain.depesz.com/s/YVw
Do you understand how postgresql calculate the row estimate ?
BR
Mathieu VINCENT
2015-12-17 10:14 GMT+01:00 Matteo Grolla :
> Thank you both for the help!
> happy holidays
>
> 2
, the estimate is good : http://explain.depesz.com/s/gCX
Have a good day
Mathieu VINCENT
2015-12-15 11:21 GMT+01:00 Gunnar "Nick" Bluth <
gunnar.bluth.ext...@elster.de>:
> Am 15.12.2015 um 10:49 schrieb Andreas Kretschmer:
> > Gunnar Nick Bluth wrote:
> >
> >>
Hello,
No one to help me to understand this bad estimation rows ?
Mathieu VINCENT
2015-12-11 12:35 GMT+01:00 Mathieu VINCENT :
> Sorry, I forget to precise Postgresql version
>
> 'PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7
> 20120313 (Red Hat
Sorry, I forget to precise Postgresql version
'PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7
20120313 (Red Hat 4.4.7-11), 64-bit'
BR
Mathieu VINCENT
2015-12-11 9:53 GMT+01:00 Mathieu VINCENT :
> Hello,
>
> I would like to know how row estima
estimation ?
Thank you for answering
Best Regards,
<http://www.psih.fr/>PSIH Décisionnel en santé
Mathieu VINCENT
Data Analyst
PMSIpilot - 61 rue Sully - 69006 Lyon - France
On 20-10-15 19:34, Jamie Koceniak wrote:
Version:
---
PostgreSQL 9.1.14 on x86_64-unknown-linux-gnu, compiled by gcc (Debian
4.7.2-5) 4.7.2, 64-bit
Query Plan
http://explain.depesz.com/s/4s37
Nor
Thanks for the informative responses and suggestions. My responses below:
* Sorry for the double post. I posted the original message using my gmail
account and got a "is not a member of any of the restrict_post groups"
response and when I didn't see it for a day, I ended up wondering if it was
due
On 21-03-14 00:56, Stefan Amshey wrote:
We have a slow performing query that we are trying to improve, and it
appears to be performing a sequential scan at a point where it should
be utilizing an index. Can anyone tell me why postgres is opting to do
it this way?
The original query is as foll
On 03-03-14 19:24, Eli Naeher wrote:
Hello,
I have two versions of essentially the same query; one using nested
joins, the other using subselects. The version using the subselect is
roughly an order of magnitude faster (~70ms on my box and data vs
~900ms for the nested joins). Of course the o
On 05-12-13 15:09, salah jubeh wrote:
Hello guys,
When I excute a query, the exection time is about 1 minute; however,
when I execute the query with explain analyze the excution time jumps
to 10 minutes.
I have tried this for several queries, where I need to optimize; and
using explain an
ed around the initial problem by running the
delete in smaller batches.
Thanks.
--
Vincent de Phily
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
On Friday 08 July 2011 10:05:47 Dean Rasheed wrote:
> > On Thu, 2011-07-07 at 15:34 +0200, vincent dephily wrote:
> >> Hi,
> >>
> >> I have a delete query taking 7.2G of ram (and counting) but I do not
> >> understant why so much memory is necessary. The
.
We haven't tweaked effective cache size yet, it's on the TODO... like many
other things :/
--
Vincent de Phily
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
On Thursday 07 July 2011 22:26:45 Guillaume Lelarge wrote:
> On Thu, 2011-07-07 at 15:34 +0200, vincent dephily wrote:
> > Hi,
> >
> > I have a delete query taking 7.2G of ram (and counting) but I do not
> > understant why so much memory is necessary. The server has 12
n, I can easily imagine that data gets
accumulated below the nestedloop (thus using all that memory), but why
isn't each entry freed once one row has been deleted from t1 ? That
entry isn't going to be found again in t1 or in t2, so why keep it
around ?
Is there a better way to write
On Monday 21 September 2009 17:00:36 Merlin Moncure wrote:
> On Mon, Sep 21, 2009 at 10:50 AM, Vincent de Phily
>
> wrote:
> > On Friday 11 September 2009 23:55:09 Merlin Moncure wrote:
> >> On Mon, Sep 7, 2009 at 5:05 AM, Vincent d
On Friday 11 September 2009 23:55:09 Merlin Moncure wrote:
> On Mon, Sep 7, 2009 at 5:05 AM, Vincent de Phily
> wrote:
> > Table "public.message"
> > Column | Type |
On Friday 11 September 2009 23:30:37 Robert Haas wrote:
> On Mon, Sep 7, 2009 at 5:05 AM, Vincent de Phily
> wrote:
> > On Monday 07 September 2009 03:25:23 Tom Lane wrote:
> >>
> >> 99% of the time, the reason a delete takes way longer than it seems like
> &g
On Monday 07 September 2009 03:25:23 Tom Lane wrote:
> Vincent de Phily writes:
> > I've been running this simple delete since yesterday afternoon :
> >> db=# explain delete from message where datetime < '2009-03-03';
> >> Seq Scan on message (cost=0.
/'
> log_filename = '%Y-%m-%d_%H%M%S.log'
> log_rotation_size = 100MB
> log_min_duration_statement = 3
> log_line_prefix = '%t %d %p '
> datestyle = 'iso, mdy'
> lc_messages = 'C'
> lc_monetary = 'C'
> lc_numeric = &
ng pqxx to access the database, if that makes any difference.
--
Vincent
>
> It takes more then 0.05s :(
>
> Only this function reduce server speed max to 20request per second.
First, benchmarking using only PHP is not very accurate, you're probably
also measuring some work that PHP needs to do just to get started in the
first place.
Second, this 20r/s is not requests
> Hi,
>
> I recently inherited a very old (PostgreSQL 7.0.3) database, and have
> migrated it to 8.2.4 but have run into a performance issue.
>
Did you configure the 8.2.4 server to match the memory requirements etc of
the old server? PostgreSQL's default settings are usually not aimed at
optimal
I'd have to agree with you about the specific SAN/setup you're working
with there. I certainly disagree that it's a general property of SAN'sthough. We've got a DS4300 with FC controllers and drives, hosts aregenerally dual-controller load-balanced and it works quite decently.
How are you guys do
Any suggestions? FYI the original question wasn't meant as a poke at comparing PG to MySQL to DB2. I'm not making an yvalue judgements either way. I'm just trying to understand how we can use it the best way possible.
Actually we just thought about something. With PG, we can create an index that is
I'd have to agree with you about the specific SAN/setup you're working
with there. I certainly disagree that it's a general property of SAN'sthough. We've got a DS4300 with FC controllers and drives, hosts aregenerally dual-controller load-balanced and it works quite decently.
How are you guys
On 6/19/06, Tim Allen <[EMAIL PROTECTED]> wrote:
As I noted in another thread, the HBA is an Emulex LP1050, and they havea rather old driver for it. I've recommended that they update ASAP. Thishasn't happened yet.Yeah, I saw that in a later thread. I would suggest also that the BIOS settings on the
decibel=# create index test on i ( sum(i) );ERROR: cannot use aggregate function in index _expression_
decibel=#BTW, there have been a number of proposals to negate the effect of nothaving visibility info in indexes. Unfortunately, none of them have cometo fruition yet, mostly because it's a very
On 6/15/06, Tim Allen <[EMAIL PROTECTED]> wrote:
Is that expected performance, anyone? It doesn't sound right to me. Doesanyone have any clues about what might be going on? Buggy kerneldrivers? Buggy kernel, come to think of it? Does a SAN just not provide
adequate performance for a large database?
Any suggestions? FYI the original question wasn't meant as a poke at comparing PG to MySQL to DB2. I'm not making an yvalue judgements either way. I'm just trying to understand how we can use it the best way possible.
If anyone from the bizgres team is watching, have they done any work in this area
On 6/15/06, Mark Lewis <[EMAIL PROTECTED]> wrote:
Unfortunately SUM is in the same boat as COUNT; in order for it toreturn a meaningful result it must inspect visibility information forall of the rows.-- MarkWe'll this is interesting news to say the least. We went with PostgreSQL for our warehouse
On 6/15/06, Mark Lewis <[EMAIL PROTECTED]> wrote:
DB2 can satisfy the query using only indexes because DB2 doesn't doMVCC.Although MVCC is generally a win in terms of making the database easierto use and applications less brittle, it also means that the database
must inspect the visibility informat
I'm not a programmer so understanding the optimizer code is WAY beyond my limits.My question, that I haven't seen answered elsewhere, is WHAT things can affect the choice of an index scan over a sequence scan. I understand that sometimes a sequence scan is faster and that you still have to get the
On 6/14/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
On Wed, Jun 14, 2006 at 02:11:19PM -0400, John Vincent wrote:> Out of curiosity, does anyone have any idea what the ratio of actual> datasize to backup size is if I use the custom format with -Z 0 compression
> or the tar format?-
time gzip -6 claDW_PGSQL.test.bakreal 3m4.360suser 1m22.090ssys 0m6.050sWhich is still less time than it would take to do a compressed pg_dump. On 6/14/06,
Scott Marlowe <[EMAIL PROTECTED]> wrote:
How long does gzip take to compress this backup?On Wed, 2006-06-14 at 15:59, John V
use thier own logins when developing new reports. Only when they get published do they convert to the Actuate user.
-- John E. Vincent[EMAIL PROTECTED]
Out of curiosity, does anyone have any idea what the ratio of actual datasize to backup size is if I use the custom format with -Z 0 compression or the tar format? Thanks.On 6/14/06,
Scott Marlowe <[EMAIL PROTECTED]> wrote:
On Wed, 2006-06-14 at 09:47, John E. Vincent wrote:> -- this is
On 6/14/06, Scott Marlowe <[EMAIL PROTECTED]> wrote:
On Wed, 2006-06-14 at 09:47, John E. Vincent wrote:> -- this is the third time I've tried sending this and I never saw it get> through to the list. Sorry if multiple copies show up.>> Hi all,
BUNCHES SNIPPED> work_mem
provide I would greatly appreciate it.
I know that the COPY performance was bumped up in 8.1 but I'm stuck on
this 8.0 box for a while longer.
Thanks,
John E. Vincent
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
ing our DBAs for not realizing the 18GB instance memory thing though ;)
--Jim C. Nasby, Sr. Engineering Consultant
[EMAIL PROTECTED]Pervasive Software http://pervasive.comwork: 512-231-6117vcard: http://jim.nasby.net/pervasive.vcf
cell: 512-569-9461-- John E. Vincent[EMAIL PROTECTED]
On 6/13/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
On Tue, Jun 13, 2006 at 05:40:58PM -0400, John Vincent wrote:> Maybe from a postgresql perspective the cpus may be useless but the memory> on the pSeries can't be beat. We've been looking at running our warehouse
> (P
.vcf cell: 512-569-9461---(end of broadcast)---TIP 9: In versions below
8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match-- John E. Vincent
[EMAIL PROTECTED]
On 2003-07-22 09:04:42 +0200, Alexander Priem wrote:
> Hi all,
>
> Vincent, You said that using RAID1, you don't have real redundancy. But
> RAID1 is mirroring, right? So if one of the two disks should fail, there
> should be no data lost, right?
>
Right. But the proposa
undancy should a single disk fail.
I'd use RAID-5 if you absolutely cannot use more disks, but I would use
RAID-10 or two RAID-1 partitions if you can afford to use 4 disks.
Vincent van Leeuwen
Media Design - http://www.mediadesign.nl/
---(end of broadcast)-
consider though:
- new files won't be created with the same options (I think), so you'll have
to run this command as a daily cronjob or something to that effect
- chattr is probably more filesystem-specific than a noatime mount, although
this isn't a problem on ext[23] ofcour
on ext3
(yes, better than XFS, JFS or ReiserFS) with a linux 2.4.21 kernel. Be sure to
mount noatime and to create the ext3 partition with the correct stripe size of
your RAID array using the '-R stride=foo' option (see man mke2fs).
Vincent van Leeuwen
Media Des
ome
different setups under your own database load to see what works best for you.
Vincent van Leeuwen
Media Design - http://www.mediadesign.nl/
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
st)---
> > TIP 8: explain analyze is your friend
> >
>
> Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
> Systems Administrator @ hub.org
> primary: [EMAIL PROTECTED] secondary: [EMAIL PROTECTED]|postgresql}.org
>
> ---(end of broadcast)---
> TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Vincent van Leeuwen
Media Design - http://www.mediadesign.nl/
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
56 matches
Mail list logo
