On 3/15/06, maarten roosendaal <[EMAIL PROTECTED]> wrote:
> Hi,
>
> We are currently having a problem that our Postgres DB
> is throwing an SQL error which states that it's 'out
> of memory'.
>
> What we have is a DB with 1 table that has 3.9 million
> records. We need to find certain records that
Hi
I'm new to Postgres, but I've been having fun with it. In our
application we want to be able to store a variable number of
keywords for a record.
I first thought that an array column would be the way to go, but
after reading caveats on performance, I implemented they keywords
as a separate t
Hi,
We are currently having a problem that our Postgres DB
is throwing an SQL error which states that it's 'out
of memory'.
What we have is a DB with 1 table that has 3.9 million
records. We need to find certain records that are to
be processed by a Java App so we do a "select id from
table wher
On Tue, Mar 14, 2006 at 23:27:24 -0500,
Stephen Frost <[EMAIL PROTECTED]> wrote:
> * Bruno Wolff III ([EMAIL PROTECTED]) wrote:
> > On Mon, Mar 13, 2006 at 17:50:44 -0600,
> > Kevin Grittner <[EMAIL PROTECTED]> wrote:
> > > Short of being compelled by law to open our records, I'm not
> > > comf
* Bruno Wolff III ([EMAIL PROTECTED]) wrote:
> On Mon, Mar 13, 2006 at 17:50:44 -0600,
> Kevin Grittner <[EMAIL PROTECTED]> wrote:
> > Short of being compelled by law to open our records, I'm not
> > comfortable providing any performance comparison which names the
> > vendor.
>
> An open records
"Brandon Keepers" <[EMAIL PROTECTED]> writes:
> On 3/13/06, Tom Lane <[EMAIL PROTECTED]> wrote:
>> Ugh :-( How many blobs have you got, thousands?
> Looks like there's over 17,000 blobs. :( But they're all very small,
> if that makes a difference.
No, it's just the number of 'em that counts.
Hi people,I was using postgres 7.2.1 in a Debian Woody server (in prodution).The machine crashed and when I restart it the following error occurs a lot in log.2006-03-14 14:35:23 [11858] ERROR: XLogFlush: request 102/7407C864 is not satisfied --- flushed only to 102/4CFEC030
2006-03-15 00:26:38 [
On 14/03/2006, at 6:52 PM, Merlin Moncure wrote:to the original poster...it's probably possible. one way would be tosanity check pg_proc on the C side (at the least, check the # args). there might be better/faster ways thoughI just finished an implementation based on the suggestions of Michael Fuh
On Mar 13, 2006, at 9:24 PM, CSN wrote:
I'm updating a field via a web form, and an em-dash is
getting stored in the database as 'âÂ-', and is
getting displayed back on the web page as '— '. The
encoding of the database is SQL_ASCII - should I
change it? And if so, to what and how?
Yes, yo
On Mar 14, 2006, at 3:10 PM, CSN wrote:
If you're going to be putting emdashes, letters with
lines and circles above them, and similar stuff that's
mostly European and American in a database, what's a
good default encoding to use - UTF-8?
Yes, UTF-8 is good because it can represent every pos
On 3/14/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Tue, Mar 14, 2006 at 07:21:51AM -0800, Nick Johnson wrote:
> > On 14/03/2006, at 12:05 AM, Michael Fuhr wrote:
> > >Why do you need to do this? What problem are you trying to solve?
> >
> > I want to associate Postgres functions with rows of
On Mon, Mar 13, 2006 at 17:50:44 -0600,
Kevin Grittner <[EMAIL PROTECTED]> wrote:
>
> Short of being compelled by law to open our records, I'm not
> comfortable providing any performance comparison which names the
> vendor.
An open records request inquiring about vendors and contracts with the
On 14/03/2006, at 10:26 AM, Michael Fuhr wrote:On Tue, Mar 14, 2006 at 07:21:51AM -0800, Nick Johnson wrote: On 14/03/2006, at 12:05 AM, Michael Fuhr wrote: Why do you need to do this? What problem are you trying to solve? I want to associate Postgres functions with rows of a table (eg, a table c
Marcos wrote:
Hi,
I have a search engine and for increase the performance I want to turn
off the stats of Postgresql but i don't know if i should do it.
Edit your postgresql.conf file, turn them off and then restart postgresql.
--
Postgresql & php tutorials
http://www.designmagick.com/
-
Thanks for your response, Josh. Actually
I’m looking for the most general way to do this, since my remote database
might not be psql. In fact, I will probably be streaming through a java
process. So I’d like to go from the java process directly into the psql
db. Is it still possible?
Chris Condit wrote:I'm new to Postgres and have a question about bulk loading from streams.I know that I can bulk load from a file using COPY. Is it possible touse a stream instead of a file? If so, and I limited to stdin? I'mattempting to stream data from a remote database into my Postgresi
Hi All-
I'm new to Postgres and have a question about bulk loading from streams.
I know that I can bulk load from a file using COPY. Is it possible to
use a stream instead of a file? If so, and I limited to stdin? I'm
attempting to stream data from a remote database into my Postgres
instance. I
On 3/13/06, Tom Lane <[EMAIL PROTECTED]> wrote:
> Brandon Keepers <[EMAIL PROTECTED]> writes:
> > Thanks for your quick response! I had actually just been trying that
> > (with 7.1) and came across another error:
>
> > NOTICE: ShmemAlloc: out of memory
> > NOTICE: LockAcquire: xid table corrupte
>>> On Tue, Mar 14, 2006 at 2:08 am, in message
<[EMAIL PROTECTED]>, Simon Riggs
<[EMAIL PROTECTED]> wrote:
> On Mon, 2006- 03- 13 at 13:27 - 0600, Kevin Grittner wrote:
>> Even more important is the fast response we have had when posting
>> problems to the lists. We have normally had a fix with
You will get better, faster answers by sending questions to a
PostgreSQL mailing list. By emailing me directly you may not get a
timely response if I don't have time to answer. Others can then
answer and learn from the subsequent discussion. I'm ccing this to
pgsql-general.
On Mar 15, 200
Hi,
On Tue, 2006-03-14 at 11:08 -0700, Brendan Duddridge wrote:
> Do you know if pgcluster will work with PostgreSQL 8.1.3?
I haven't tested but as far as I can read from web page, 1.5.0rc1 works
on 8.1.1 -- They now have rc7, and maybe it works on 8.1.3, but I don't
know...
Regards,
--
The Pos
On 3/14/06 2:55 PM, "Louis Gonzales" <[EMAIL PROTECTED]> wrote:
> Did you try to ./configure w/out "--enable-thread-safety?" I recently
> compiled postgreSQL 8.0.1 on Solaris and _needed_ --enable-thread-safety
> strictly for building Slony-I against postgresql with that feature enabled.
>
> Wh
On Mar 14, 2006, at 1:31 PM, Casey Duncan wrote:
On Mar 13, 2006, at 5:25 PM, Casey Duncan wrote:
[..]
If I restart the postmaster, the query will complete in the expected
time.
Does the problem eventually start happening again? If so, after
how long? How did you determine that the restart i
On Mar 13, 2006, at 5:25 PM, Casey Duncan wrote:
[..]
If I restart the postmaster, the query will complete in the expected
time.
Does the problem eventually start happening again? If so, after
how long? How did you determine that the restart is relevant? Do
you consistently see different (pr
On 14/3/06 20:43, "Wes" <[EMAIL PROTECTED]> wrote:
> On 3/13/06 5:50 PM, "Kevin Grittner" <[EMAIL PROTECTED]> wrote:
>
> I'm not a lawyer, but I believe things such as what vendors a government
> entity is using is required by law to be public information.
Maybe in some jurisdictions, but tha
Wes wrote:
Hmm.. What vendor throws such a clause into all their licensing agreements.
Sounds suspiciously like Microsoft...
I'm not a lawyer, but I believe things such as what vendors a government
entity is using is required by law to be public information.
Wes
I think we can safely as
Wes,
Did you try to ./configure w/out "--enable-thread-safety?" I recently
compiled postgreSQL 8.0.1 on Solaris and _needed_ --enable-thread-safety
strictly for building Slony-I against postgresql with that feature enabled.
What is the reason you are compiling this _with_ the feature?
If it'
Short of being compelled by law to open our records, I'm not
comfortable providing any performance comparison which names the
vendor.
Hmm.. What vendor throws such a clause into all their licensing agreements.
Sounds suspiciously like Microsoft...
Or Oracle, DB2, Sybase, Progress ..
I try to build 8.1.3 with:
./configure --prefix=/usr/local/pgsql8.1.3 --with-openssl --with-pam
--enable-thread-safety
It fails the openssl test, saying openssl/ssl.h is unavailable. Digging
deeper, I find that it is because the test program with
#include
is failing because it can't inclu
On 3/13/06 5:50 PM, "Kevin Grittner" <[EMAIL PROTECTED]> wrote:
> The license for the commercial product contains a clause which
> prohibits disclosing benchmarks of their product without their written
> permission. (Heaven only knows why they would include such a clause.)
> My comment is not bas
Hello list,
I have the need to audit a purchase order process that mainly deals with
PO header and details table, users need to know at any given time how
the purchase order was, like a snapshot, I already log any change to a
separate parallel table.
One way I could do is log each change in
Ho Marcos!
You can also try to adpat this parameters to your config:
TUNING:
* First, see:
http://www.lyris.com/lm_help/6.0/tuning_postgresql.html
* Adjust this params in your "/etc/sysctl.conf" to obtain the
best performances:
kernel.shmmax=7000
kernel.s
Hi,
I have a search engine and for increase the performance I want to turn
off the stats of Postgresql but i don't know if i should do it.
Should I make this?
Thanks.
Marcos
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
Tom Lane wrote:
Bryan White <[EMAIL PROTECTED]> writes:
ec=# \z bulkuploadcfg
Access privileges for database "ec"
Schema | Table |Access privileges
+---+
If you're going to be putting emdashes, letters with
lines and circles above them, and similar stuff that's
mostly European and American in a database, what's a
good default encoding to use - UTF-8?
CSN
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail
Bryan White <[EMAIL PROTECTED]> writes:
> ec=# \z bulkuploadcfg
> Access privileges for database "ec"
> Schema | Table |Access privileges
> +---+--
>
On Tue, Mar 14, 2006 at 07:21:51AM -0800, Nick Johnson wrote:
> On 14/03/2006, at 12:05 AM, Michael Fuhr wrote:
> >Why do you need to do this? What problem are you trying to solve?
>
> I want to associate Postgres functions with rows of a table (eg, a
> table column of datatype regproc or regpr
"Ed L." <[EMAIL PROTECTED]> writes:
> If we want to handle 16 clusters on this one box, each
> with 300 max_connections and 2000 relations, would it be
> ball-park reasonable to say that worst case we might have 300
> backends with ~2000 open file descriptors each (300 * 2000 =
> 600K open file
Do you know if pgcluster will work with PostgreSQL 8.1.3?
Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAIL PROTECTED]
ClickSpace Interactive Inc.
Suite L100, 239 - 10th Ave. SE
Calgary, AB T2G 0V9
http://www.clickspace.co
Tom Lane wrote:
You need to revoke them as that user, likely. REVOKE really means
"revoke grants I made", not "revoke any grant anybody made".
Ok I tried logging is as that user. Oddly after the revoke then only
grant that disappeared was one I created.
Maybe it has something to do with 'g
On Tuesday March 14 2006 10:46 am, Tom Lane wrote:
> "Ed L." <[EMAIL PROTECTED]> writes:
> > We have 3 clusters with 24K, 34K, and 47K open files
> > according to lsof. These same clusters have 164, 179, and
> > 210 active connections, respectively. Their schemas,
> > counting the number of user
"Ed L." <[EMAIL PROTECTED]> writes:
> One lsof curiosity is that one cluster seems to have it's
> partition directory listing open about 10K times, including
> many times by the same backend process:
Nah, that's just an lsof aberration on HPUX --- it doesn't always tell
the truth about files' nam
"Ed L." <[EMAIL PROTECTED]> writes:
> We have 3 clusters with 24K, 34K, and 47K open files according to
> lsof. These same clusters have 164, 179, and 210 active
> connections, respectively. Their schemas, counting the number
> of user and system entries in pg_class as a generously rough
> me
On Tuesday March 14 2006 10:31 am, Ed L. wrote:
> On Tuesday March 14 2006 10:25 am, Tom Lane wrote:
> > "Ed L." <[EMAIL PROTECTED]> writes:
> > > We're trying to make sense of the number of open files on
> > > an HP-UX 11.23 system that's getting several new 8.1.2
> > > clusters, and in particular
On Tuesday March 14 2006 10:25 am, Tom Lane wrote:
> "Ed L." <[EMAIL PROTECTED]> writes:
> > We're trying to make sense of the number of open files on an
> > HP-UX 11.23 system that's getting several new 8.1.2
> > clusters, and in particular why the numbers appear to be
> > significantly larger tha
Vivek Khera <[EMAIL PROTECTED]> writes:
> not sure why you're not able to revoke permissions. that seems
> curious to me.
You need to revoke them as that user, likely. REVOKE really means
"revoke grants I made", not "revoke any grant anybody made".
regards, tom lane
-
"Ed L." <[EMAIL PROTECTED]> writes:
> We're trying to make sense of the number of open files on an
> HP-UX 11.23 system that's getting several new 8.1.2 clusters,
> and in particular why the numbers appear to be significantly
> larger than our 7.4 clusters on similar hardware. Would there
> be
We're trying to make sense of the number of open files on an
HP-UX 11.23 system that's getting several new 8.1.2 clusters,
and in particular why the numbers appear to be significantly
larger than our 7.4 clusters on similar hardware. Would there
be anything particular to 8.1.2 over 7.4 that wo
On Mar 14, 2006, at 9:54 AM, Bryan White wrote:
How can I clean this up. Would dropping the user have any effect?
This is on 7.4 if that makes a difference.
dropping the user will leave dangling permissions (ie, Pg will report
them as being granted to user "103" or whatever Id that user h
We're currently using Ubuntu Breezy Hedgehog for our existing
PostgreSQL database server (8.0.x). A Java-based applications uses the
database server via JDBC.
I'm not sure if this question is within the context but I would like
to know if clustering can provide a hot-standby instance for a
product
On Tue, Mar 14, 2006 at 09:57:54AM +0100, Paul Mackay wrote:
> Is there a way to change the default prvilege on functions, i.e. that like
> for tables, only the creator has privilege on it by default ?
Not that I'm aware of. You could revoke USAGE on the functions'
schema so attempts to call the
On Tue, 2006-14-03 at 07:45 -0500, Andrew Rawnsley wrote:
> One doesn't 'install' oracle. That implies you have control of the
> situation. One attempts to convince it to condescend to install itself onto
> your machine.
>
> Of course, this is like convincing my 3 year old to go to bed on time.
On 14/03/2006, at 12:05 AM, Michael Fuhr wrote:
On Mon, Mar 13, 2006 at 10:45:47PM -0800, Nick Johnson wrote:
Can anyone provide me with some direction on how to write a function
I can load into postgres that will execute a function specified by
OID (or regproc/regprocedure) at runtime, with t
I have a database that has a few tables that have privileges granted by
a user that no longer works here. I am the owner of these tables and
the owner of the database. If I do any granting/revoking on these
tables my actions do not seem to affect the privs set by this other
user. The privile
One doesn't 'install' oracle. That implies you have control of the
situation. One attempts to convince it to condescend to install itself onto
your machine.
Of course, this is like convincing my 3 year old to go to bed on time. Such
powers of persuasion are not common.
On 3/13/06 5:41 PM, "Sco
Hi,
On Tue, 14 Mar 2006, Thomas Hallgren wrote:
If you're using JDBC, the C-JDBC (http://c-jdbc.objectweb.org/) might be a
good option.
Definitely. I've read some papers on C-JDBC 3 years ago, and was really
satisfies with its features.
Regards,
--
The PostgreSQL Company - Command Prompt,
If you're using JDBC, the C-JDBC (http://c-jdbc.objectweb.org/) might be a good
option.
Regards,
Thomas Hallgren
Devrim GUNDUZ wrote:
Hi,
On Tue, 14 Mar 2006, Jojo Paderes wrote:
Is it possible to cluster PostgreSQL? If yes where can I find the
resource information on how to implement it?
Jojo Paderes wrote:
Is it possible to cluster PostgreSQL? If yes where can I find the
resource information on how to implement it?
--
http://jojopaderes.multiply.com
http://jojopaderes.wordpress.com
---(end of broadcast)---
TIP 4: Have you search
Hi,
On Tue, 14 Mar 2006, Jojo Paderes wrote:
Is it possible to cluster PostgreSQL? If yes where can I find the
resource information on how to implement it?
You can use pgcluster: http://pgcluster.projects.postgresql.org/ (I
haven't tried it yet)
Of course, you can install any clustering s
Is it possible to cluster PostgreSQL? If yes where can I find the
resource information on how to implement it?
--
http://jojopaderes.multiply.com
http://jojopaderes.wordpress.com
---(end of broadcast)---
TIP 4: Have you searched our list archives?
r irussel wrote:
Hello Every body:
I have implemented psql version 7.4.2 on Debian linux version 3.2
and it was running very well. At this moment it is being crashed when
executing a single select statement. Details are mentionded as
follows:
You really should be running something later than 7
Mary wondered:>I am wondering how i could create stored procedure using postgresqlSee chapters 35ff in the Server programming manual @
http://www.postgresql.org/docs/8.1/interactive/server-programming.htmlBest wishesHarald-- GHUM Harald Massapersuadere et programmareHarald Armin MassaReinsburgstra
I am wondering how i could create stored procedure using postgresql
I hope anyone could give me directions for that
Thanks,
Mary
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Is there a way to change the default prvilege on functions, i.e. that like for tables, only the creator has privilege on it by default ?Thanks.PaulOn 3/14/06,
Michael Fuhr <[EMAIL PROTECTED]> wrote:On Tue, Mar 14, 2006 at 09:24:52AM +0100, Paul Mackay wrote:
> It seems that any user has the right
>> I have stored proc that retrieves a bunch of data, stores it in temp =
>> table, computes all sorts of totals/averages/whatnots from the temp =
>> table, and inserts results in another table. It works fine (except I =
>> don't like wrapping all SQL statements in 'execute'), but multiple
>> cal
On Tue, Mar 14, 2006 at 09:24:52AM +0100, Paul Mackay wrote:
> It seems that any user has the right to execute a function, whether or not
> it has been granted the EXECUTE privilege on it. Even a REVOKE EXECUTE has
> no impact. A privilige error will be raised only if the function tries to
> access
It seems that any user has the right to execute a function, whether or not it has been granted the EXECUTE privilege on it. Even a REVOKE EXECUTE has no impact. A privilige error will be raised only if the function tries to access an object (ex.: a table) for witch the user doesn't have the appropr
Have you tried the initcap function?
select initcap('abcd efgh');
initcap
---
Abcd Efgh
John
Emi Lu wrote:
Hello all,
Does anyone have available plpgsql codes to update all capital letters
in a column to "the first character is capital and the rest is small" ?
For example, in
On Mon, 2006-03-13 at 13:27 -0600, Kevin Grittner wrote:
> Even more important is the fast response we have had when posting
> problems to the lists. We have normally had a fix within 24 hours.
> Frankly, the support has been amazing.
Kevin, well done. We've all watched your progress with intere
On Mon, Mar 13, 2006 at 10:45:47PM -0800, Nick Johnson wrote:
> Can anyone provide me with some direction on how to write a function
> I can load into postgres that will execute a function specified by
> OID (or regproc/regprocedure) at runtime, with type safety? I've been
> able to write suc
Hello Every body: I have implemented psql version 7.4.2 on Debian linux version 3.2 and it was running very well. At this moment it is being crashed when executing a single select statement. Details are mentionded as follows: DB Dump size before this problem is arised: 95 MB DB ENCODING
71 matches
Mail list logo