Karsten Hilbert <[EMAIL PROTECTED]> writes:
> > Depends on whether you need "random access" to the contents. You can
> > lo_seek() inside a large object and retrieve parts of the data with
> > lo_read(), while 'text' and 'bytea' currently require fetching the
> > whole file.
> Not so unless I mis
In looking at top, I have noticed when doing some
long queries that RAM memory is only being used
at 1-3%. While, CPU often jumps to 97, 98, even
99% utilization (which is great!).
Is this normal for RAM utilization?
If not, how can I better utilize my RAM during
queries and or general process
I have a table from which I'm trying to extract certain information. For
historical reasons, we archive every action on a particular thing
('thing' is identified, funnily enough, by 'id'). So the only way to
find out the current state of a particular combination of attributes is
to "select dist
I currently have a DB setup with ENCODING = UNICODE. Are all char, and
varchars stored as UNICODE? I predominantly work in a SQL Server
environment, and there we have varchar for regular ASCII, and nvarchar for
Unicode, so the extra space is used only when necessary. I just wanted to
find out if PG
Hi.
Where is the SQL text of view stored in the database?
I mean the text like "SELECT the_field FROM the_table".
I can found the function's text in "pg_proc.proerc", but can't find the same
for a view.
Yury Shvetsov.
---(end of broadcast)---
TIP
Dear Gurus,
I have a similar problem as discussed in
http://archives.postgresql.org/pgsql-novice/2003-06/msg00321.php
This probably should go to pgsql-novice too, but I'm not a member of that
list so please forgive my lazyness.
I use Debian Woody Linux and installed postgres (v7.2.1), but I need
> Depends on whether you need "random access" to the contents. You can
> lo_seek() inside a large object and retrieve parts of the data with
> lo_read(), while 'text' and 'bytea' currently require fetching the
> whole file.
Not so unless I misunderstand. We use substr() on bytea for
chunking acces
"Rick Gigger" <[EMAIL PROTECTED]> writes:
> I will search the archives but does anyone know off the top of their head
> which performs better?
It really depends on what you are trying to do. If you are always
fetching the entire file from the database, 'bytea' *might* have a
little less overhead
I will search the archives but does anyone know off the top of their head
which performs better?
- Original Message -
From: "Keith C. Perry" <[EMAIL PROTECTED]>
To: "Rick Gigger" <[EMAIL PROTECTED]>
Cc: "PgSQL General ML" <[EMAIL PROTECTED]>
Sent: Tuesday, November 18, 2003 12:25 PM
Subje
Quoting Rick Gigger <[EMAIL PROTECTED]>:
> What is the best method for storing files in postgres? Is it better to use
> the large object functions or to just encode the data and store it in a
> regular text or data field?
>
>
> ---(end of broadcast)--
"Rick Gigger" <[EMAIL PROTECTED]> writes:
> What is the best method for storing files in postgres? Is it better to use
> the large object functions or to just encode the data and store it in a
> regular text or data field?
Depends on whether you need "random access" to the contents. You can
lo_
On Tue, Nov 18, 2003 at 12:39:40PM -0600, Ron Johnson wrote:
> Supplanting PITR with Replication? If so, I don't think that's
No, I think the idea is that if you're already using the replication
system, you can get this for nothing along with it. Yes, it'll cost
you in hardware.
A
--
An
What is the best method for storing files in postgres? Is it better to use
the large object functions or to just encode the data and store it in a
regular text or data field?
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please
On Tue, 2003-11-18 at 08:29, Andrew Sullivan wrote:
> On Tue, Nov 18, 2003 at 03:01:15PM +0100, Rafael Martinez Guerrero wrote:
> > References in mailinglists talk about version 7.4 and in the TODO list
> > is under the section 'urgent'.
>
> It didn't get done.
>
> > Anybody knows when this funct
Hello,
I am having problems running postmaster.
I get the following error:
DEBUG: invoking IpcMemoryCreate(size=1466368)
PANIC: invalid checksum in control file
The postmaster then exits.
What control file is it talking about?
Is this a common error?
Thanks for any help
Peter
--
Hi,
I am using PostgreSQL 7.4, but I did have the same problem with the
last version.
I indexed the column word (defined as varchar(64)) using lower(word).
If I use the following query, everything is fine, the index is used and
the query is executed very quickly:
select * from token where
Quoting Gianni Mariani <[EMAIL PROTECTED]>:
> Keith C. Perry wrote:
>
> >I had this same issue as well but now I'm *slightly* concerned since most of
> my
> >code is perl. How soon would issue be reviewed? (not that I'm NOT going to
> use
> >your patch for right now).
> >
>
> I suspect that thi
Keith C. Perry wrote:
I had this same issue as well but now I'm *slightly* concerned since most of my
code is perl. How soon would issue be reviewed? (not that I'm NOT going to use
your patch for right now).
I suspect that this is only an issue when you use
"--enable-thread-safety" which accordi
Quoting "Keith C. Perry" <[EMAIL PROTECTED]>:
> Quoting Gianni Mariani <[EMAIL PROTECTED]>:
>
> > Gianni Mariani wrote:
> >
> > >
> > > Before I go deep into this - does anyone have the quick fix for this ?
> > >
> > > Some facts - the 7.3.4 version of plperl.c has the same errors in the
> > >
Quoting Gianni Mariani <[EMAIL PROTECTED]>:
> Gianni Mariani wrote:
>
> >
> > Before I go deep into this - does anyone have the quick fix for this ?
> >
> > Some facts - the 7.3.4 version of plperl.c has the same errors in the
> > 7.4 tree.
> > The 7.4 version of plperl.c (with some error handli
Hello,
i've been reading the README file in the lmgr folder (in src/backend/storage/lmgr/)
and i have a couple of questions about locks:
- What's the difference between the Lightweight Locks (LWLocks) and the Regular
locks (Heavyweight Locks)? For example, if i do a query and it needs a lock, w
Someone at E-Week magazine is looking for users who have upgraded to 7.4
or are considering it. If interested, please email
[EMAIL PROTECTED] with information about your current
PostgreSQL usage.
Thanks.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED]
On Tue, 18 Nov 2003, Alex wrote:
> Hi,
> I am trying to return a recod from from my function but for some reason
> it does not work.
>
> Here is may problem. I use a for loop to generate the first batch of
> records. Once the loop is completed I want to add another record. But at
> that point fail
None to begin with. You have to tell it to. Then you have to tell it to
allow connections on that port. PostgreSQL comes configured to NOT let
outside computers connect until you change things, enhancing security.
You want to read the admin guide located here:
http://www.postgresql.org/docs/
Is dump-->initdb-->reload
required for RC2 --> 7.4 ?
Regds
Mallah.
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Martijn van Oosterhout wrote:
That's right, pg_constraint didn't exist before 7.3. In the contrib
directory there is a script called adddepend which attempts to create the
missing records for you.
And much to my dismay, it has a bug (or a serious limitation).
Table (before):
...
Indexes: ix_foo
Rafael Martinez Guerrero <[EMAIL PROTECTED]> writes:
> Anybody knows when this functionality will be available with
> prod-quality?
It's likely to show up in 7.5 which it is hoped would be released around the
middle of next year. However as this is free software and dependent on
volunteers and o
I am looking at PostgreSQL as a possible option for our backend database. I am also
evaluating Oracle. What kind of paid
support does PostgreSQL offer?
Jason Tesser
Web/Multimedia Programmer
Northland Ministries Inc.
(715)324-6900 x3050
---(end of broadcast)---
I think it was delayed until 7.5... same for win32 port.
Here ir Bruce's message talkin about both topics: http://archives.postgresql.org/pgsql-hackers/2003-07/msg00284.php
On Tue, 2003-11-18 at 11:01, Rafael Martinez Guerrero wrote:
Hello
I am trying to find out when 'Point-in-time data re
Hello
I am trying to find out when 'Point-in-time data recovery' functionality
will be available with postgreSQL but I can not find concrete info about
this.
References in mailinglists talk about version 7.4 and in the TODO list
is under the section 'urgent'.
Anybody knows when this functionalit
* Oliver Elphick ([EMAIL PROTECTED]) wrote:
> On Tue, 2003-11-18 at 13:19, Stephen Frost wrote:
> > > plr needs to build in the source tree, so the easiest way to do that is
> > > to include it in the source. The same goes (or did go) for the others.
> >
> > I don't think this is really the case.
On Tue, 2003-11-18 at 13:19, Stephen Frost wrote:
> > plr needs to build in the source tree, so the easiest way to do that is
> > to include it in the source. The same goes (or did go) for the others.
>
> I don't think this is really the case. I was working on repackaging
> PostgreSQL for Debian
* Oliver Elphick ([EMAIL PROTECTED]) wrote:
> On Tue, 2003-11-18 at 12:59, Peter Eisentraut wrote:
> > Oliver Elphick writes:
> >
> > > Please note that the python packages have been dropped from this build,
> > > since the PyGreSQL source tree is now independent. Another maintainer
> > > will ta
On Tue, 2003-11-18 at 12:59, Peter Eisentraut wrote:
> Oliver Elphick writes:
>
> > Please note that the python packages have been dropped from this build,
> > since the PyGreSQL source tree is now independent. Another maintainer
> > will take those on.
>
> Then why are plr, odbc, pgeasy and pgp
Debian packages of 7.4 have been uploaded to Debian's experimental
archive. Because of certain issues with interlocking dependencies, I
will not move them to unstable until version 7.3.4-9 is accepted into
the testing distribution. This is not a reflection on 7.4's quality but
the result of a lon
35 matches
Mail list logo
