Can a single database be split over multiple filesystems, or does the
filesystem size under e.g. Linux (whatever it is these days) constrain
the database size?
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or
colleagues]
--
Hi,
Hope you can help me out.
I'm trying to write a select statement which returns the all the columns of
a table with a 'not null' modifier.
I realise that I will need to use the system tables but can't work out which
columns of which system tables to include in my statement.
Thanks for any h
Ian Willis wrote:
>
> Postgresql transparently breaks the db into 1G chunks.
Yes, but presumably these are still in the directory tree that was
created by initdb, i.e. normally on a single filesystem.
> The main concern is during dumps. A 10G db can't be dumped if the
> filesustem has a 2G limi
En un mensaje anterior, Tatsuo Ishii escribió:
> > Sorry... I mean non-ASCII chars doesn't look good on PgAccess plus
> > they are stored as 'garbage' (really two characters).
>
> For Japanese, an UNICODE database and TCL 8.3 combo works well. What
> kind of charset (encoding) are you using? Can
How to drop a table and it's sequence(s) automaticaly ?
Is there any way to find all sequence of a table with a query (without \d) ?
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail comma
think this should do it:
select attname from pg_attribute
where attnotnull = 't'
and attrelid =
(select oid from pg_class where relname = 'tablename');
regards,
tamsin
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Graeme Longman
Sent: 11 July 2001 13
Sure, here it comes.
/Buckis
-Original Message-
From: Adam Manock [mailto:[EMAIL PROTECTED]]
Sent: den 11 juli 2001 16:26
To: Christian Bucanac
Subject: RE: [GENERAL] Performance tuning for linux, 1GB RAM, dual CPU?
We should move this discussion back to the list... others may benefit
For the last few days, I cannot read the postgres mailing lists
because the news.postgresql.org server is refusing nntp connections.
Is this something that will be fixed anytime soon? Please let me know
directly, as obviously I am not able to read this list at this time.
There is no indication o
On 9 Jul 2001, Andrew Mayo wrote:
> Questions:-
Answers:- online documentation covers 90% of what you would think of asking about pg
> 1. Does it support the full ANSI-92 SQL syntax especially left, right
> outer join functionality. If not, does it even support outer joins?
yes it does
> 2.
> ze_database=> CREATE TABLE my_table (
> ze_database(> p1 integer,
> ze_database(> p2 integer,
> ze_database(> p3 integer,
> ze_database(> p4 integer);
> CREATE
> ze_database=> CREATE FUNCTION my_add(integer,integer,integer,integer)
> ze_database-> RETURNS integer
> ze_database-> AS 'INSERT INTO
Christian Bucanac <[EMAIL PROTECTED]> writes:
>> I am going to try 768M (98304) for buffers and 6144 (6144 * 32 = 192M)
>> for sort mem. This way with the DB server serving a max of 32 application
>> servers the kernel and other processes should still have the last 64Mb RAM.
This is almost certai
In my logs, I find a lot of these:
NOTICE: current transaction is aborted, queries ignored until end of
transaction block
should I be concerned? Is there a place where I can read about the
difference messages that may appear in the log file?
Thanks!
- Ryan Mahoney
---
Outgoing ma
is there a way in postgres to change just a part of a text data in a
column. for example if i have a column called description with the
following data:
+-+
| description |
+-+
| this is a test. |
+-+
and i want to change th
UPDATE tablename SET description=(substring(description for position('test' in
description))||'exam'||substring(description from position('test' in
description)+char_length('test')));
Keep in mind that this will only replace the first occurence of the word 'test' in the
description and that d
>This is almost certainly a lousy idea. You do *not* want to chew up all
>available memory for PG shared buffers; you should leave a good deal of
>space for kernel-level disk buffers.
I decided to start high on buffers because of Bruce's:
http://www.ca.postgresql.org/docs/hw_performan
Hi Adam,
There are a few links to benchmark-type things you might find useful at
:
http://techdocs.postgresql.org/oresources.php#benchmark
Hope they're useful.
:-)
Regards and best wishes,
Justin Clift
Adam Manock wrote:
>
> >This is almost certainly a lousy idea. You do *not* want to ch
Is Postgresql ready for 24/7 uptime? Our tests have shown that vacuumdb
requires downtime, and if one does this nightly as suggested, well, one has
downtime, 40+ minutes in our case.
My company wants to replace MS SQL Server with PostgreSQL, but we can't
afford downtime to do database mainte
Hi Mark, This is being worked on now. I believe the 7.2 release will have
enable you to run a vacuum with no downtime.
-r
At 03:39 PM 7/11/01 -0600, Mark wrote:
>Is Postgresql ready for 24/7 uptime? Our tests have shown that vacuumdb
>requires downtime, and if one does this nightly as sugge
We increased shared memory in the linux kernel, which decreased the vacuumdb
time from 40 minutes to 14 minutes on a 450 mhz processor. We calculate that
on our dual 1ghz box with ghz ethernet san connection this will go down to
under 5 minutes. This is acceptable to us. Sorry about the unn
On Wed, Jul 11, 2001 at 03:55:46PM -0600, Mark wrote:
:
: We increased shared memory in the linux kernel, which decreased the vacuumdb
: time from 40 minutes to 14 minutes on a 450 mhz processor. We calculate that
: on our dual 1ghz box with ghz ethernet san connection this will go down to
:
> Christopher Masto <[EMAIL PROTECTED]> writes:
> > I guess maybe I'm expecting too much magic optimization.
>
> You're expecting the system to transform
>
> (SELECT foo UNION SELECT bar) WHERE condition
>
> into
>
> (SELECT foo WHERE condition) UNION (SELECT bar WHERE condition)
>
> Christian Bucanac <[EMAIL PROTECTED]> writes:
> >> I am going to try 768M (98304) for buffers and 6144 (6144 * 32 = 192M)
> >> for sort mem. This way with the DB server serving a max of 32 application
> >> servers the kernel and other processes should still have the last 64Mb RAM.
>
> This is a
> Richard Huxton <[EMAIL PROTECTED]> writes:
> > "Thomas T. Veldhouse" wrote:
> >> Why does it ask 4 times?
>
> > createlang is just a script - it basically runs "/path/to/psql $QUERY" -
> > each query connects a separate time.
>
> Note that running a setup that requires password auth for the DB
Is there a way to figure out which file represents which table?
IE: I have a file 21691 and I want to know what table it is.
Also, I've heard that pg splits tables when they get to about 1 gig.
I have a table that could grow to that. It is 700+ megs now. Will
performance/indexes be effected
> "J.H.M. Dassen (Ray)" wrote:
> >> and it was never submitted to us a a patch.
> >
> >According to the README it was. Oliver, could you comment on this please?
>
> It was, a couple of months back. Peter made some criticism of its use of
> autoconf, which I have changed. I have not resubm
is it at all possiable to reorder a squence? I'm
finding that our sequences get some what out step and messed and would like to
ocassionaly reorder them, though I'm unable to find anything that might be able
to do this.
Mike
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> OK, I've changed the vacuum code now so your index doesn't get
> departialised. The changes seem pretty obvious so they're probably right.
> They certainly didn't seem to break my simple tests. How does one test that
> VACUUM works properly?
Si
Hello,
I have created table/view pairs like:
CREATE TABLE foo (
key integer not null,
value text not null,
active timestamp not null default now(),
deactive timestamp
);
CREATE VIEW v_foo AS
SELECT * FROM foo WHERE deactive IS NULL;
This allows the user-interface component of the application t
Nils Zonneveld <[EMAIL PROTECTED]> wrote:
> I'm searching for a web hosting company that also supports PostgreSQL
> and that is based in the Netherlands. Does anyone know a good one?
Ones that I'm aware of are
- Business Internet Trends, http://www.bit.nl
- Cistron Internet Services, http://www.c
Eric Chacon wrote:
>
> I'm sure I'm doing something stupid, but this is driving me nuts...
>
> This is the first stored procedure I've ever written in my life.
You're close, debugging plpgsql can be tricky:
> DROP FUNCTION update_flag_func();
> CREATE FUNCTION update_flag_func()
> RETURNS text
On Wed, Jul 11, 2001 at 04:09:51AM -0400, Mike Mascari wrote:
> Hello,
>
> I have created table/view pairs like:
[snip]
Yes, creating a unique partial index should be possible and will do what you
want I think, (I couldn't totally follow what you meant).
However, partial indicies will not supp
Martijn van Oosterhout wrote:
>
> On Wed, Jul 11, 2001 at 04:09:51AM -0400, Mike Mascari wrote:
> > Hello,
> >
> > I have created table/view pairs like:
>
> [snip]
>
> Yes, creating a unique partial index should be possible and will do what you
> want I think, (I couldn't totally follow what yo
I just wrote:
> What are the limits of the WHERE expression? Must they be composed of
> constant expressions or can they be more complex?
[snip]
Sorry. I see the SGML in your patch:
"Each element can only consist of ATTR OP CONST and these can only be
joined by
AND and OR operators."
Mike Mas
From: "Vijayan" <[EMAIL PROTECTED]>
> I have a registration database. I need to know number of
> registrations / month in a report format. How will I get a report like
> this ?
>
> In Oracle I can give the query like this:-
> "select to_char(reg_date, 'Mon '), cou
On Wed, Jul 11, 2001 at 10:17:25AM +0100, Richard Huxton wrote:
> From: "Vijayan" <[EMAIL PROTECTED]>
> >
> > When I tried in psql, it gave this error. "No such function
> > 'to_char' with the specified attributes". But in postgre there is a
> Try "\df to_char" to see how/if to_char is defin
I would like to make it impossible to be traced as to which record came in
first and which next, however, being sequential reveal that... How should I
ensure this?
Thanx
- Original Message -
From: "Peter Eisentraut" <[EMAIL PROTECTED]>
To: "Kapil Tilwani" <[EMAIL PROTECTED]>
Cc: <[EMAIL
Do all *NIX programs work on all others ? Do Unix programs run on Linux and
vice-versa... ??? Would FreeBSD UNIX programs work on SCO-Unix, etc.?
Thanx
- Original Message -
From: "Trond Eivind Glomsrød" <[EMAIL PROTECTED]>
To: "Kapil Tilwani" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
guard wrote:
> please help
> how to configure pltcl
Seems you want to build that on Windomps, right?
Never did it, so I don't know exactly . But I see possible
problems here. The Windows port uses the CygWIN environment.
The pltcl object, which has to be loaded into the backe
On Wed, Jul 11, 2001 at 12:06:05PM +, [EMAIL PROTECTED] wrote:
> > Linus no longer has a filesystem file size limit ( or at least on
> > that you'll hit easily)
>
> I'm not concerned with "easily". Telling one of our customers that we
> chose a particular server becuase they won't easily hit
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> Does somewhere check for duplicate oids?
The duplicate_oids script in the same directory.
In practice, what really matters is that no two entries in the same
system catalog have the same OID; it wouldn't matter if we had, say,
the same OID use
Mike Mascari <[EMAIL PROTECTED]> writes:
> To enforce uniqueness because
> deactive is NULL, I cannot just create an index like:
> CREATE UNIQUE INDEX i_foo (value, deactive);
It's not clear to me what you are really after here. You *can* create a
unique index, even though 'deactive' is allowed
Tony,
The GetProcedures function in the driver does not work.
You should be able to a simple select of the stored proc however
Dave
On July 11, 2001 09:06 am, Tony Grant wrote:
> Hello,
>
> I am trying to use a stored procedure via JDBC. The objective is to be
> able to get data from more than
Tom Lane wrote:
>
> Mike Mascari <[EMAIL PROTECTED]> writes:
> > To enforce uniqueness because
> > deactive is NULL, I cannot just create an index like:
>
> > CREATE UNIQUE INDEX i_foo (value, deactive);
>
> It's not clear to me what you are really after here. You *can* create a
> unique index
Kapil Tilwani writes:
> I would like to make it impossible to be traced as to which record came in
> first and which next, however, being sequential reveal that... How should I
> ensure this?
If you want cryptographic security you will need to use advanced
algorithms to shuffle your data. In a
OK, I've changed the vacuum code now so your index doesn't get
departialised. The changes seem pretty obvious so they're probably right.
They certainly didn't seem to break my simple tests. How does one test that
VACUUM works properly?
I think it's time to send it to pgsql-patches now, unless som
On 11 Jul 2001 10:20:29 -0400, Dave Cramer wrote:
> The GetProcedures function in the driver does not work.
OK. I bet it is on the todo list =:-D
> You should be able to a simple select of the stored proc however
Yes! thank you very much!!!
SELECT getcountryname(director.country)
did the tri
On Thu, Jul 12, 2001 at 01:39:07PM +0900, Tatsuo Ishii wrote:
> > Christopher Masto <[EMAIL PROTECTED]> writes:
> > > I guess maybe I'm expecting too much magic optimization.
> >
> > You're expecting the system to transform
> >
> > (SELECT foo UNION SELECT bar) WHERE condition
> >
> > into
47 matches
Mail list logo