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
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
mill
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.
> >
On Fri, Apr 29, 2011 at 1:23 AM, Toby Corkindale
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 customer with a 50GB d
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 tri
>
> \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: raghav
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 databas
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 t
On Thu, Apr 28, 2011 at 10:59 PM, Simon Riggs wrote:
> On Wed, Apr 27, 2011 at 5:24 PM, Phoenix Kiula
> wrote:
>> Possibly a dumb question but there isn't much about this.
>> http://www.google.com/search?sourceid=chrome&ie=UTF-8&q=postgresql+null+value+disk+space
>> I have some BOOLEAN columns.
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 Apr
On Thu, Apr 28, 2011 at 12:12 AM, Phoenix Kiula wrote:
> > 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 gives me
> idea
On Thu, Apr 28, 2011 at 4:07 PM, Karsten Hilbert
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 leads to bad ta
>
> 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
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: pgsql-general@p
Seb 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 resea
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
> http://www.postgresql.org/doc
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
Post
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 LOC
Sukuchha Shrestha 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 into a csv wh
On Thu, Apr 28, 2011 at 7:00 PM, Mark Felder wrote:
> On Thu, 28 Apr 2011 17:27:04 -0500, Basil Bourque 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 their servers in our
> da
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. Ha
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
lar
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
Post
25 matches
Mail list logo
