On Tue, May 15, 2007 at 09:20:53PM +0200, PFC wrote:
> >From an outside perspective it just
> >seems odd that potentially a large amount of data would be pulled off
> >disk into memory that is never used. Perhaps there's an overriding
> >reason for this.
>
> Yeah, where would you put this d
Hi all,
I am using Postgresql 8.2.
I am using client side api to upload/download files to/from postgresql using
calls lo_export()/lo_import();
If I download a file from postgresql, few weeks later, files object's
contents got damaged.
I don't know why.
Do any of you have encountered same probl
I have a PostgreSQL 7.4.14 database that is being backed up nightly
using pg_dump. Some time back, we deleted a user from the server that
was no longer employed. This in turn caused some problems with ownership
of some of the tables (since the user didn't exist, the database could
only go by th
Daniel Barlow wrote:
> Questions:
> 1) this is on a system with I believe to be quiescent - there is only
> one client open which is not doing anything. Before I get more involved
> with this, can someone just confirm that pgstat will continue to update
> this file even when nothing is happening?
Jeff MacDonald escribió:
> On 5/15/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> >Jeff MacDonald escribió:
> >> On 5/15/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
> >> >Jeff MacDonald wrote:
> >> >> Hi,
> >> >>
> >> >> I think the subject says it all. I need to install contrib/xml from
> >> >
On 5/15/07, Jeff MacDonald <[EMAIL PROTECTED]> wrote:
I even tried
gmake -I/usr/include/libxml2/libxml
no go.
try -I/usr/include/libxml2
--
Best regards,
Nikolay
---(end of broadcast)---
TIP 4: Have you searched our list archives?
On 5/15/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
Jeff MacDonald escribió:
> On 5/15/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
> >Jeff MacDonald wrote:
> >> Hi,
> >>
> >> I think the subject says it all. I need to install contrib/xml from
> >> the 7 series, not contrib/xml2 from the 8 se
Jeff MacDonald escribió:
> On 5/15/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
> >Jeff MacDonald wrote:
> >> Hi,
> >>
> >> I think the subject says it all. I need to install contrib/xml from
> >> the 7 series, not contrib/xml2 from the 8 series.
> >>
> >> See below for my attempted build
> >>
>
On 5/15/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
Jeff MacDonald wrote:
> Hi,
>
> I think the subject says it all. I need to install contrib/xml from
> the 7 series, not contrib/xml2 from the 8 series.
>
> See below for my attempted build
>
> http://www.suite2101.com/help/pgsql
>
> Please le
Jeff MacDonald wrote:
Hi,
I think the subject says it all. I need to install contrib/xml from
the 7 series, not contrib/xml2 from the 8 series.
See below for my attempted build
http://www.suite2101.com/help/pgsql
Please let me know if you have any ideas.
looks like you are missing your -dev
Hi,
I think the subject says it all. I need to install contrib/xml from
the 7 series, not contrib/xml2 from the 8 series.
See below for my attempted build
http://www.suite2101.com/help/pgsql
Please let me know if you have any ideas.
--
Unless otherwise indicated, anything I write is either
Thus, if there are a whole bunch of columns on each table, the data in
those extra columns (e.g. - all columns aside from "id", the one that
was asked for in the result set) will indeed be drawn into memory.
Yeah, I wanted to mean that ;)
All the columns are loaded (except the TOASTed
On May 15, 2007, at 12:02 PM, Bill Moseley wrote:
On Tue, May 15, 2007 at 01:42:18PM -0400, Chris Browne wrote:
[EMAIL PROTECTED] (PFC) writes:
SELECT o.id
FROM order o
JOIN customer c on o.customer = c.id
Does that bring into memory all columns from both order and
customer?
M
Thus, if there are a whole bunch of columns on each table, the
data in
those extra columns (e.g. - all columns aside from "id", the one that
was asked for in the result set) will indeed be drawn into memory.
Is that specific to Postgresql? From an outside perspective it just
seems odd that po
On Tue, May 15, 2007 at 01:42:18PM -0400, Chris Browne wrote:
> [EMAIL PROTECTED] (PFC) writes:
> >> SELECT o.id
> >> FROM order o
> >> JOIN customer c on o.customer = c.id
> >>
> >> Does that bring into memory all columns from both order and customer?
> >> Maybe that's not a good examp
One other possible reason for splitting the table up in two chunks is to
grant different rights on the 2 sets of columns.
Susan Cassidy
Bill Moseley <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/15/2007 09:44 AM
To
Postgres General
cc
Subject
Re: [GENERAL] Performance issues of one vs
[EMAIL PROTECTED] (PFC) writes:
>> SELECT o.id
>> FROM order o
>> JOIN customer c on o.customer = c.id
>>
>> Does that bring into memory all columns from both order and customer?
>> Maybe that's not a good example due to indexes.
>
> No, it just pulls the columns you ask from the
Richard Huxton wrote:
> It calls archive_command on the just-filled one.
Good to know, thanks. I think I'll experiment a bit with
archive_command. My point was that since I know (or better assume) that
old segments are going to stay in my pg_xlog for *days* before getting
recycled, just copying th
Mr.Kraisak Kesorn wrote:
Dear all
I try to install PostgreSQL on WindowsXP (Professional Ed). Unfortunately, I
could not complete install process because there are two errors at copy new
file stage.
1. At the first time of installing, the error said "Internal account
lookup failure: No m
SELECT o.id
FROM order o
JOIN customer c on o.customer = c.id
Does that bring into memory all columns from both order and customer?
Maybe that's not a good example due to indexes.
No, it just pulls the columns you ask from the table, nothing less,
nothing more.
Splitting tab
On Tue, May 15, 2007 at 07:51:44AM +0200, Dawid Kuroczko wrote:
> On 5/15/07, Bill Moseley <[EMAIL PROTECTED]> wrote:
> >On Tue, May 15, 2007 at 06:33:26AM +0200, Dawid Kuroczko wrote:
> >> Well, views are not going to help with memory consumption here.
> >> It is the table contents that gets cache
I'm sure there's a point where you'd be saving a "substantial" amount
of disk space using a non-normalized scheme, but, like you say, you'd
be missing out on other things. In general, disks are cheap while the
man hours used to try to fix data corruption is not.
On May 15, 2007, at 7:35 AM,
Dear all
I try to install PostgreSQL on WindowsXP (Professional Ed). Unfortunately, I
could not complete install process because there are two errors at copy new
file stage.
1. At the first time of installing, the error said "Internal account
lookup failure: No mapping between account
While looking for ways to get some more battery life from my laptop, I
noticed that one source of periodic disk writes was the postgres stats
collector process, which appears to write to pgstat.tmp every 500ms. I
could turn it off (in fact, for the moment I have), but I rather like
having working
Hi,
Probably you might be using reserved words (ip_address). Please try with out
using the reserved words.
Regards
Prashant Ranjalkar
On 5/14/07, Jasbinder Singh Bali <[EMAIL PROTECTED]> wrote:
Hi,
In one of my trigger functions, i'm trying to catch invalid ip address
exception
CREATE OR R
Hi,
The procedure you followed is for online backups. The backups are useless
unless you set archive_command in your postgresql.conf file. This command
will copy the filled transaction log to a directory where you specified in
your archive_command. The PG won't write to transaction logs unless it
Can anyone provide input on this question? I'm curious how to look at
this from a disk and memory usage perspective. Would using a bit
column type help much?
I'm not thrilled by the loss of referential integrity.
On Mon, May 14, 2007 at 01:37:18PM -0700, Bill Moseley wrote:
>
> Say I have a ta
Marco Colombo wrote:
Mmm, sorry I'm not sure I'm following here. Maybe I should provide some
background. In my pg_xlog directory I see five files, WAL segments, I
suppose. Only one (as I expected) is begin currently used, the others
are old (one a couple of days old).
When PG performs a switch f
Tom Lane wrote:
> No. You have to have an actual archive_command script copying the WAL
> segments somewhere else when told to. An asynchronous copy of the xlog
> directory will be nothing but garbage, because we recycle WAL segments
> as fast as we can (ie, as soon as the archive_command claims
Andrus wrote:
> I need to create function GOMONTH which returns date by given number of
> month before or forward using sql or pgsql in 8.1+
> For example,
> GOMONTH( DATE '20070513', 1 ) should return date '20070613'
> GOMONTH( DATE '20070513', -2 ) should return date '20070313'
>
> I tried
>
On Mon, May 14, 2007 at 08:46:23PM -0300, marcelo Cortez wrote:
> hi all
>
> there any was successful with connect to postgres
> with psqlodbc in dsn less mode? It's wrong list for
> this subject? any pointer be appreciated
Certainly, all the time. For example (unix people close your eye
31 matches
Mail list logo
