Hello Friends,
I want start contributing in Postgres in code level. I read some ppts and some
tutorials in postgres manual.
Can you please suggest me some links where I can learn:
1. Transaction Isolation in Database
2. Query procession and possible optimizations.
3. How to
On Wed, Sep 4, 2013 at 2:19 PM, Tomas Vondra wrote:
> On 4.9.2013 20:52, Jeison Bedoya Delgado wrote:
>> Hi merlin, Thanks for your interest, I'm using version 9.2.2, I have
>> a machine with 128GB RAM, 32 cores, and my BD weighs 400GB. When I
>> say slow I meant that while consultations take or f
On 4.9.2013 20:52, Jeison Bedoya Delgado wrote:
> Hi merlin, Thanks for your interest, I'm using version 9.2.2, I have
> a machine with 128GB RAM, 32 cores, and my BD weighs 400GB. When I
> say slow I meant that while consultations take or failing a copy with
> pgdump, this taking the same time bef
Hi merlin,
Thanks for your interest, I'm using version 9.2.2, I have a machine with
128GB RAM, 32 cores, and my BD weighs 400GB. When I say slow I meant
that while consultations take or failing a copy with pgdump, this taking
the same time before had 10K disks in raid 10 and now that I have SSD
On Tue, Sep 3, 2013 at 11:15 PM, Roberto Grandi
wrote:
> Hi kevin
>
> first of all thanks for your help. I did a mistake we are using postgres 8.3.
>
> I didn't expect COPY TO frees space but I was wondering Autovacumm delete
> dead rows as soon as possible, in fact my scenario is:
>
> - Delete a
On Wed, Sep 4, 2013 at 10:22 AM, Jeison Bedoya Delgado
wrote:
> Hello, in order to improve the performance of my database included in the
> solution SAN SSD disk on RAID 10, but I see that the performance of the
> database is the same. whichpostgresql.conf parameters that I do recommend to
> chang
On Tue, Sep 3, 2013 at 2:34 PM, Jesper Krogh wrote:
> On 03/09/13 09:47, Craig Ringer wrote:
>
> On 09/03/2013 03:46 PM, jes...@krogh.cc wrote:
>
> Hi.
>
> I have a strange situation where generating the query plan takes 6s+ and
> executing it takes very little time.
>
> How do you determine that
Hello, in order to improve the performance of my database included in
the solution SAN SSD disk on RAID 10, but I see that the performance of
the database is the same. whichpostgresql.conf parameters that I do
recommend to change for use writing more.
Thank you very much.
--
Sent via pgsql-p
On 9/4/2013 3:01 AM, Johan Loubser wrote:
I am tasked with getting specs for a postgres database server for the
core purpose of running moodle at our university.
The main question is at the moment is 12core AMD or 6/8core (E Series)
INTEL.
What would be the most in portend metric in planning a
Johan Loubser wrote:
> I am tasked with getting specs for a postgres database server for the
> core purpose of running moodle at our university.
> The main question is at the moment is 12core AMD or 6/8core (E Series)
> INTEL.
>
> What would be the most in portend metric in planning an enterprise
I am tasked with getting specs for a postgres database server for the
core purpose of running moodle at our university.
The main question is at the moment is 12core AMD or 6/8core (E Series)
INTEL.
What would be the most in portend metric in planning an enterprise level
server for moodle.
--
Roberto Grandi wrote:
> we are using postgres 8.3.
> my scenario is:
>
> - Delete all products record for a vendor
> - Reload all products record (from new listing) for the same
> vendor.
>
> Obviously we repeat this process continously and table space is
> growing really fast.
>
> Can you sug
12 matches
Mail list logo