On 04/26/2011 10:30 AM, Toby Corkindale wrote:
I see Intel is/was claiming their SLC SSDs had a *minimum* lifetime of
2PB in writes for their 64GB disks; for your customer with a 50GB db
and 20GB/day of WAL, that would work out at a minimum lifetime of a
million days, or about 273 years!
The
Seb wrote:
Thanks for these thoughts. Perhaps I can describe a cartoon of this
database to explain what I'm trying to accomplish.
The database stores information related to biological research. The
bulk of the tables describe things like individual ID, morphometrics,
and behavioural data on
On 29 Apr 2011, at 5:03, Seb wrote:
So typically we have two types of uses: research and
preparation/logistics for the project. We wouldn't want to even see the
logistcs tables for research work, whereas we would like to see only
these ones for preparation/planning. As the project and
On 2011-04-20, Emi Lu wrote:
Hello,
ROW_NUMBER() is only ready in 8.4. For 8.3, is there a simple
way to get
row_number
select row_number(), col1, col2...
FROM tableName
You definitely want to skim through the SQL Cookbook
(http://www.oreilly.de/catalog/9780596009762/) for this
On 29/04/11 16:35, Greg Smith wrote:
On 04/26/2011 10:30 AM, Toby Corkindale wrote:
I see Intel is/was claiming their SLC SSDs had a *minimum* lifetime of
2PB in writes for their 64GB disks; for your customer with a 50GB db
and 20GB/day of WAL, that would work out at a minimum lifetime of a
On Thursday, April 28, 2011 11:44:37 PM Jeff Davis wrote:
On Thu, 2011-04-28 at 07:29 +0200, pasman pasmański wrote:
Hi. Yesterday i have an idea, that sometimes row locks may be skipped,
when table is already locked with LOCK command. It may to reduce an
overhead from row locks.
What do
On Fri, Apr 29, 2011 at 1:23 AM, Toby Corkindale
toby.corkind...@strategicdata.com.au wrote:
On 29/04/11 16:35, Greg Smith wrote:
On 04/26/2011 10:30 AM, Toby Corkindale wrote:
I see Intel is/was claiming their SLC SSDs had a *minimum* lifetime of
2PB in writes for their 64GB disks; for your
hello group,
I just started to use postgresql and i want to import data using copy command
in
a loop.
Here is what i did !
1) following content with name loaddata.sql.
\copy table from 'C:\psql\x.txt';
\copy table from 'C:\psql\y.txt';
2) My loaddata.sql is located in C:\psql\ therefore i
\i C:\psql\loaddata.sql
But it says C:: Permission denied
Give the permission to postgres user on 'loaddata.sql' file. Right click and
in properties give full access to postgres user.
Best Regards,
Raghavendra
EnterpriseDB Corporation
The Enterprise Postgres Company
Email:
Hello nice people,
I am sure many of you have idea about how to connect matlab with postgresql.
Connecting with matab database toolbox is possible which i have not tried yet
because i dont have access to that toolbox.
I have read in internet that its possible to connect without having a
On Friday, April 29, 2011 4:01:03 am Raghavendra wrote:
\i C:\psql\loaddata.sql
But it says C:: Permission denied
Give the permission to postgres user on 'loaddata.sql' file. Right click
and in properties give full access to postgres user.
Just to be clear this means the user you
On Thu, Apr 28, 2011 at 10:59 PM, Simon Riggs si...@2ndquadrant.com wrote:
On Wed, Apr 27, 2011 at 5:24 PM, Phoenix Kiula phoenix.ki...@gmail.com
wrote:
Possibly a dumb question but there isn't much about this.
I figure you have a reason for considering using nulls but since you didn't
explain the underlying problem you are trying to solve it is hard to comment or
consider. If you share there may someone who can provide a solution that
doesn't violate best practices and common sense.
David J.
On
On Thu, Apr 28, 2011 at 12:12 AM, Phoenix Kiula phoenix.ki...@gmail.comwrote:
Vick's presentation at
http://cdn.mailermailer.com/documents/PGCon2008TablePartitioningCaseStudy.pdf
Thanks everyone for the excellent suggestions.
Vick/Greg, thanks in particular for this reference. The doc
On Thu, Apr 28, 2011 at 4:07 PM, Karsten Hilbert
karsten.hilb...@gmx.net wrote:
On Thu, Apr 28, 2011 at 03:39:19PM -0500, Merlin Moncure wrote:
They are fairly pervasive, and increasingly so, which I find to be
really unfortunate. Personally I think rote use of surrogate keys is
terrible and
Thanks everyone for the excellent suggestions.
Vick/Greg, thanks in particular for this reference. The doc gives me
ideas for other things too!
+1
I've been trying to get the OSCON folk to accept this talk for several
years now, to reach a wider audience. Seems they don't like me...
Try using this, even on a windows system:
\i /psql/loaddata.sql
psql likes *nix path names
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Sukuchha Shrestha
Sent: Friday, April 29, 2011 5:40 AM
To:
Seb spluque at gmail.com writes:
The database stores information related to biological research. The
bulk of the tables describe things like individual ID, morphometrics,
and behavioural data on all the individuals in several studies.
However, there are a few tables that do not relate to the
Alban thank for your ideas
It probably is, the default Postgres settings are quite modest and GIN
indexes are memory hungry.
I think you need to increase shared_buffers. With 2.5GB of memory (such a
strange number) the docs suggest about 250MB.
See
Vick Khera wrote:
I've been trying to get the OSCON folk to accept this talk for several
years now, to reach a wider audience. Seems they don't like me... :(
Too specific for OSCON. It's not you, it's the topic. I've tried
submitting far more generic things than that, but still with a
On Fri, 2011-04-29 at 10:25 +0200, Andres Freund wrote:
On Thursday, April 28, 2011 11:44:37 PM Jeff Davis wrote:
On Thu, 2011-04-28 at 07:29 +0200, pasman pasmański wrote:
Hi. Yesterday i have an idea, that sometimes row locks may be skipped,
when table is already locked with LOCK
Sukuchha Shrestha sukuchha at yahoo.de writes:
Could anybody explain here how to connect in a detailed step ! Consider me
studying in class 1 of postgresql when explaining :)
It may not be much help to you, but on a Unix shell I tend to run psql through
some text manipulation pipes and then
On Thu, Apr 28, 2011 at 7:00 PM, Mark Felder f...@feld.me wrote:
On Thu, 28 Apr 2011 17:27:04 -0500, Basil Bourque basil.l...@me.com wrote:
So, while I can't specifically recommend their products, I certainly
suggest considering them.
Customer of ours is probably lurking on here. We host
I've been using PostgreSQL pretty steadily for the past year and am
interesting in joining/attending a users group meeting. I've searched for a
users group in the San Francisco/Peninsula/Silicon Valley area (I'm in
Redwood City), but all I've found are references to a San Francisco group
where the
On Fri, 2011-04-29 at 14:58 -0700, Rick Genter wrote:
I've been using PostgreSQL pretty steadily for the past year and am
interesting in joining/attending a users group meeting. I've searched
for a users group in the San Francisco/Peninsula/Silicon Valley area
(I'm in Redwood City), but all
http://sfbayarea.fullcalendar.com/ec/org/1419
please give a quick hello to Larry Ellison for me!
l8r
Martin
__
Jogi és Bizalmassági kinyilatkoztatás/Verzicht und
Vertraulichkeitanmerkung/Note de déni et de confidentialité
Ez az
üzenet bizalmas.
On 04/29/2011 06:42 AM, Scott Marlowe wrote:
I think you misunderstood. He's not storing 480GB on the drives,
that's how much WAL is moving across it. It could easily be a single
80GB SSD drive or something like that.
Right; that's why you don't necessarily get saved by the fact that
On 04/29/2011 06:13 PM, Jeff Davis wrote:
I'm not sure which reference you found, but SFPUG is certainly active
with meetings every month.
http://pugs.postgresql.org/sfpug ; last meeting listed there is January
2009.
--
Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD
28 matches
Mail list logo