Gavin M. Roy wrote:
Feel free to link away :)
Gavin
Adam Ruth wrote:
...Also, if you prefer, I can mirror it on
my server and post that link so as to not chew up your bandwidth.
Just make sure you get someone to mirror it before it hits Slashdot.
That way it's someone else's server that gets tu
Feel free to link away :)
Gavin
Adam Ruth wrote:
I've mentioned your predicament to the Yahoo SCO message board, and
some have asked to see the letter. Would you mind if I showed it (I
won't if you'd prefer I don't) Also, if you prefer, I can mirror it on
my server and post that link so as t
I've mentioned your predicament to the Yahoo SCO message board, and
some have asked to see the letter. Would you mind if I showed it (I
won't if you'd prefer I don't) Also, if you prefer, I can mirror it on
my server and post that link so as to not chew up your bandwidth.
Also, the same reques
> The whole point here is: it is assumed that backup/restore of tablespaces can
> hapen quite quickly and as simple as to copy tablespace files from one
> location to another(even while database is on - WAL can be used to handle
> this) - this is compared to dump.
This
I agree that RAID provides similar performance benifits especially with striping io
benifits, however it is powerful and ideal to have both options. For example you may
have a set of tables that are read-only for reporting and another set mostly write
only. You could have they resting on diff
On Wednesday 21 January 2004 22:20, Alex Madon wrote:
> Well the top issued was corresponding to a concurrency of 20 (so a level
> where swap is not sollicited).
> With a concurrency of 60, swap is very high
>
> Here is a "movie" of how swap is maanged (a snapshot every 5 sec)
[used sits around 110
On Wednesday 21 January 2004 22:29, [EMAIL PROTECTED] wrote:
> After copied pg database from one PC to another
>
> -I could not find plpgsql function(s) in the copied database.
> -had to instal plpgsql language handler again
>
> -whilst tables and data moved fine
>
> The copy incl
On Wednesday 21 January 2004 20:12, D. Dante Lorenso wrote:
> NEVERMIND... This is not a trigger problem. It's a unique
> constraint problem... If I have a unique constraint on
> a column like 'afile_version', and want to do an update on
> that column to add one to each number, is there a way to
On Wed, Jan 21, 2004 at 04:54:26PM -0700, scott.marlowe wrote:
> On Wed, 21 Jan 2004, Kragen Sitaker wrote:
> > ... subject like 'Couldn%'" ... But I'm using Postgres 7.3.4, and
> > it doesn't seem to have varchar_pattern_ops in its pg_opclass.opcname. ...
>
> The only way to make that version wo
Excellent response!
On Jan 21, 2004, at 3:50 PM, Gavin M. Roy wrote:
Here is a copy of the letter which I've sent out today:
http://www.gavinroy.com/~gavinr/SCO%20Response.pdf
We'll see their response and act accordingly. Thanks for all the
feedback everyone.
Gavin
Alex Satrapa wrote:
Gavi
On Wed, Jan 21, 2004 at 04:47:57PM -0700, scott.marlowe wrote:
> On Wed, 21 Jan 2004, Alex Madon wrote:
>
> > PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
> > 7 root 16 0 00 0 SW1.2 0.0 0:07 0
> > kscand/Normal
> > 5 root 15
<[EMAIL PROTECTED]> writes:
> After copied pg database from one PC to another
> -I could not find plpgsql function(s) in the copied database.
> -had to instal plpgsql language handler again
Please define "could not find plpgsql function(s)". What *exactly*
did you do, and what exact
On Wed, 21 Jan 2004, Kragen Sitaker wrote:
> I'd like to be able to do queries like "select count(*), fromline from
> message where subject like 'Couldn%'" quickly. I see that, in current
> Postgres, I can do this with an index like "create index message_subject
> on message using btree(subject v
On Wed, 21 Jan 2004, Andrew Sullivan wrote:
> On Wed, Jan 21, 2004 at 11:23:40AM -0700, Rick Gigger wrote:
> >
> > Yes but sometimes an enterprise level application may need to be put on a
> > laptop and taken off-line. Having an embedded database that is compatible
> > with the one on the serve
Mike Mascari <[EMAIL PROTECTED]> writes:
> Could you give me a bit of direction?
> [ same query works in one DB and crashes in another ]
I have a feeling this is a problem with an incorrect plan --- possibly
the same thing I just fixed a few days ago,
http://archives.postgresql.org/pgsql-committe
On Wed, 21 Jan 2004, Alex Madon wrote:
> One can see that at the maximum feeling of swap (74700k free swap), the
> full picture is:
>
>
> 22:51:54 up 3:58, 6 users, load average: 47.38, 18.53, 7.79
> 131 processes: 130 sleeping, 1 running, 0 zombie, 0 stopped
> CPU states: 5.3% user 3.
Tom Lane wrote:
In a nutshell:
CREATE TEMPORARY TABLE foo AS
SELECT DISTINCT ON (x, y, z) *
FROM bar;
crashes the backend and screws up data pages associated with the catalog under
7.4.1.
Works for me ...
...
Perhaps providing a specific test case would help.
Could you give me a bit o
I'd like to be able to do queries like "select count(*), fromline from
message where subject like 'Couldn%'" quickly. I see that, in current
Postgres, I can do this with an index like "create index message_subject
on message using btree(subject varchar_pattern_ops)". But I'm using
Postgres 7.3.4,
On Tue, 20 Jan 2004 01:07:00 +, Simen Brekken wrote:
> Hi,
>
> I'm currently running 7.3.4 on Debian/testing, I've been trying to get
> pgxml_dom working but after doing some normal tests I find that it
> segfaults the postmaster whenever it hits an error, is this because
> the contrib modul
Here is a copy of the letter which I've sent out today:
http://www.gavinroy.com/~gavinr/SCO%20Response.pdf
We'll see their response and act accordingly. Thanks for all the
feedback everyone.
Gavin
Alex Satrapa wrote:
Gavin M. Roy wrote:
My problem is the threat from SCO is not from the blea
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Happened to me too sometime.
If you look at the messages generated by your import you should see errors
complaining about the missing plpgsql handler. If there is no handler the
procedures will not be imported. The import code usually has something
Oh, I like that added touch :)
On Wed, 21 Jan 2004, Joshua D. Drake wrote:
> Marc G. Fournier wrote:
>
> >you should invite him in to talk, and let him know that you are
> >investigating drop'ng Linux altogether and are curious as to what
> >SCO/UnixServer could offer ... basically, tell him y
Marc G. Fournier wrote:
you should invite him in to talk, and let him know that you are
investigating drop'ng Linux altogether and are curious as to what
SCO/UnixServer could offer ... basically, tell him you are looking at
options, and take up his time on 'the sales pitch' :)
But before
you should invite him in to talk, and let him know that you are
investigating drop'ng Linux altogether and are curious as to what
SCO/UnixServer could offer ... basically, tell him you are looking at
options, and take up his time on 'the sales pitch' :)
On Wed, 21 Jan 2004, Gavin M. Roy wrote:
>
Could be problem be that PHP is not using connection efficiently?
Apache KeepAlive with PHP, is a dual edged sword with you holding the
blade :-)
If I am not mistaken, what happens is that a connection is kept alive
because Apache believes that other requests will come in from the client
who ma
Is support for tablespaces a priority feature for 7.5? I believe there
has been significant development in this area and it seems that
postgres' file structure opens it up nicely to support it. What are the
chances this will be completed?
In my opinion, it really is a critical feature to suppor
On Wednesday 21 January 2004 14:11, Alex Madon wrote:
> Hello,
> I am testing a web application (using the DBX PHP function to call a
> Postgresql backend).
> I have 375Mb RAM on my test home box.
[10 connections is fine, 100 is not]
> I tried to change some parameters in postgresql.conf
> max_con
On Wed, 21 Jan 2004, Alex Madon wrote:
> Hello,
> I am testing a web application (using the DBX PHP function to call a
> Postgresql backend).
I'm not familiar with DBX. Is that connection pooling or what?
> I have 375Mb RAM on my test home box.
> I ran ab (apache benchmark) to test the behavio
Moreover, what should prevent the SCO scumbags from molesting *BSD
users if they would succeed in destroying Linux?
There might be technical reasons to move from Linux to *BSD, but the
SCO amok run should not be a reason to do so.
I agree with this. SCO has really done nothing but prove that Li
Alex Madon wrote:
Hello,
I am testing a web application (using the DBX PHP function to call a
Postgresql backend).
I have 375Mb RAM on my test home box.
I ran ab (apache benchmark) to test the behaviour of the application
under heavy load.
When increasing the number of requests, all my memory is
hello,
Iam trying to install postgres-7.4.1 on my tru64 (O.S version 5.1A) box
without the shared library support.
Here's my list of commands:
./configure --with-includes=/opt/gcc-33/include --prefix=/tools/postgres-741
--disable-shared
gmake
gmake install
The "gmake" successfully compiles the s
Linux Magazine Feb 2004 published an article titled "Postgresql 7.4: The
Database Administrator's Database". It is a 5 page article describing
in detail what and how to use the new postgres features such as
Expression indexes, arrays, data type domains, polymorphic functions,
and full text indexin
Hello,
I am testing a web application (using the DBX PHP function to call a
Postgresql backend).
I have 375Mb RAM on my test home box.
I ran ab (apache benchmark) to test the behaviour of the application
under heavy load.
When increasing the number of requests, all my memory is filled, and the
L
Hello,
After using Postgresql for a while, through ODBC / MS Access, I'm not
able to connect to the server anymore. The server reports "Too many
clients connected already".
With a "ps -afx", I can see a lot of idle postgresql connections, which
correspond for sure to ODBC connections that haven't
Jim Mercer wrote:
On Tue, Jan 20, 2004 at 06:16:46PM -0800, Gavin M. Roy wrote:
Thanks for the feedback thus far. I should also mention I use freebsd
for other stuff, but I am mainly asking in peoples experience, which is
the best for PostgreSQL to live on specifically. In terms of a nice smp
On Wed, 21 Jan 2004, Alex wrote:
> Kris,
> thanks for the reply. I dont actually use temp tables in the function
> (not that I know of) but I did truncated and reloaded a few tables incl.
> recreating indices the previous day, however the line no. indicated in
> the serverlog does not point to t
This was probably asked n-times but still:
Is there any way to end (commit/rollback) a transaction inside a stored
function?
(The reason why it is good to commit/rollback in a stored procedure is that
in C/S environment it is not uncommon to have a dead client holding
locks(unfinished transactio
On 21/01/2004 04:21 Marc G. Fournier wrote:
On Wed, 21 Jan 2004, Stephen Robert Norris wrote:
> Of course SCO is planning to sue the BSD users, too, so it's not really
> a solution.
We figure that SCO will either be bought out, or go bankrupt, before we
have to worry about them :)
If they tried th
Jenny Zhang wrote:
Jenny,
although this is old but i find it worth mentioning tom's
comment on it. I hit your comment on facing similar issue.
The cited example is pretty iffy since it assumes that the valid array
entries are all > 0. In recent PG version you can use the array_upper
and array_lo
Thanks for the feedback thus far. I should also mention I use freebsd
> for other stuff, but I am mainly asking in peoples experience, which is
> the best for PostgreSQL to live on specifically. In terms of a nice smp
> high end scsi system. Sorry for the lack of specifics on that before.
Fa
40 matches
Mail list logo
