Hi,
I am about to put a 7.1.2 server into production on RedHat 7.1
The server will be dedicated to PostgreSQL, running a bare minimum of
additional services.
If anyone has already tuned the configurable parameters on a dual PIII w/
1GB RAM then I
will have a great place to start for my performa
Am Dienstag, 10. Juli 2001 13:44 schrieb Adam Manock:
> Hi,
>
> I am about to put a 7.1.2 server into production on RedHat 7.1
> The server will be dedicated to PostgreSQL, running a bare minimum of
> additional services.
> If anyone has already tuned the configurable parameters on a dual PIII w/
On Tue, Jul 10, 2001 at 07:44:34AM -0400, Adam Manock wrote:
: Hi,
:
: I am about to put a 7.1.2 server into production on RedHat 7.1
: The server will be dedicated to PostgreSQL, running a bare minimum of
: additional services.
: If anyone has already tuned the configurable parameters on a dual
"Woo Weng Kong" <[EMAIL PROTECTED]> writes:
> Would appreciate a lot if anyone could tell me if there is any
> disadvantage/performance issue in using PostgeSQL on windows.
I wouldn't recommend such a setup for a production server; the
reliability is just not up to par. (Use Postgres on almost a
On the other end of the spectrum there are many addresses with only one
entry. When I use one of these addresses in the WHERE clause it takes
just as long as the address with 150k rows. If the sequential scan is
better for 150k rows out of 800k rows, what about 1 out of 800k? It
seems that
Hello:
I'm not able to get a proper encoding with TCL 8.3
and Postgres 7.1.2_2.
I've tried setting the DB enconding to UNICODE and still
doesn't work.
If I use TCL 8.0 the chars get stored properly on the DB but
are not shown correctly on PgAccess (they are shown in hexa)
[EMAIL PROTECTED] writes:
> On the other end of the spectrum there are many addresses with only one
> entry. When I use one of these addresses in the WHERE clause it takes
> just as long as the address with 150k rows. If the sequential scan is
> better for 150k rows out of 800k rows, what abo
Hello,
We have been putting a lot of work into Part IV of the book.
We would appreciate some fresh feedback on the chapters 9 and 10.
As always, the link:
http://www.opendocspublishing.com/entry.lxp?lxpe=92
Thanks!
OpenDocs
---(end of broadcast)--
Hello,
Try WinSQL at http://www.indus-soft.com/winsql. It is absolutely FREE and does
not expire. It is only one file and does not come with any bulky DLLs. If you
don't like it, simply delete the file from your harddisk.
Features:
--
* Connect to any database through ODBC
* Syntax Highl
On Mon, 2 Jul 2001 15:04:41 + (UTC), Richard Huxton <[EMAIL PROTECTED]>:
> There is a brief description of PG's MVCC in Linux Gazette that people might
> find of interest. Written by Joseph Mitchell of Great Bridge
>
> http://www.linuxgazette.com/issue68/mitchell.html
>
Thank you. That is
Hi There,
1. We had to make the following changes to the configure script, which
was not otherwise recognizing the presence of some libraries.
The modifications in the configure script are the following
A. Removal of -Wl from LDFLAGS
B. Addition of an empty main function ( int main() { ; retu
On Mon, Jul 09, 2001 at 08:22:43PM -0400, Tom Lane wrote:
> AFAIR, cnfify doesn't modify its inputs. But watch out for the
> difference between explicit and implicit ANDing.
OK, I'm pretty sure I got it right now.
> In practice, I seem to recall that VACUUM is broken for partial indexes
> anywa
> Is there a known problem with HASH type index in PostgreSQL 7.1.2
> 4PGDG on Red Hat Linux 7.1 (2.4.2 kernel)? I can't find a lot of
> documentation, but this is what I observe:
Tom Lane has mentioned several times that index types other than BTREE
have suffered some bit-rot over the past few
hi,
is there a editor out there with syntax highlighting for
PL/PGSQL. preferable Vim oder Xemacs.
I am using Xemacs with sql-mode, but this is only for
generic SQL AFAIK.
thanks a lot for any hint!
markus
--
Markus Jais
http://www.mjais.de
[EMAIL PROTECTED]
The road goes ever on and on - Bilbo
Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> To actually be able to use ExecInsertIndexTuples, you need to create an
> EState, a ResultRelInfo and put each tuple in a TupleSlot for a while. Does
> it sound like I'm on the right track? That's quite a few changes.
Right. I'd recommend copy
Martijn van Oosterhout writes:
> Well, getting closer. Maybe I should start version numbering the patches?
For one thing, you might want to post them to pgsql-patches instead. And
you should start generating the patches against the 7.2devel sources
because I already suspect yours generating con
> 1. I find about 50% database storage overhead in this case. That's not
completely silly, considering this is structured data, but seems a little
high. I don't know >the internal structures well enough to really see
what's happening.
Hmm, the PG docs say to expect data stored in the database t
On Tue, Jul 10, 2001 at 04:47:49PM +0200, Peter Eisentraut wrote:
> Martijn van Oosterhout writes:
>
> > Well, getting closer. Maybe I should start version numbering the patches?
>
> For one thing, you might want to post them to pgsql-patches instead. And
> you should start generating the patch
Version: Postgres 7.1.2
A product we are developing requires frequent loading
of a large number of rows into a table. We are using
the "copy file" command, but with WAL we are effectively
doubling the amount of disk writing we are doing.
After the rows are loaded we do a "create index".
Is the
On Thu, 5 Jul 2001, Tom Lane wrote:
> Ryan Mahoney <[EMAIL PROTECTED]> writes:
> > Re: killing a process from browser, I don't think what you're trying to do
> > is really possible.
>
> If the client-side code were programmed to send a Cancel request to the
> backend when the user loses interes
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.
I have a database calle
jags_content
jags_content has a table in jags_content called
update_flag
update_flag has a column of type timestamp called
content
S
Some time ago I posted to comp.databases a list of requirements which
IMHO any RDBMS product must meet to be generally useful in commercial
applications.
I got some responses back regarding Postgresql but a lot of
improvements have since been made, so I am reposting the original list
of questions
Hi every one
I have a big problem, I think it's a syntaxical one, but can't solve it,
please help !
What I am trying to do is a simple function who updates data in a table and
if no row was updated, then add a new one with the specified parameters.
And i would like to do it using SQL and anyth
Hi,
Can I write a function that can write the output to the OS(Linux OS) file.
If there is a way to do it in Postgresql It would be great.
We are using Postgresql 7.1 running in Linux Redhat 7.1.
Thanks in Advance.
Vijay
---(end of broadcast)
Hi there - we've hit a bit of a brick wall with this and I was
wondering if someone could help us out. Our MS-SQL code is this :
SELECT "Site"."Name" as "SiteName", "Site"."Description" as
"SiteDescription",
"Site"."DefaultStyle", "Site"."PageWidth",
"Site"."Tel", "Site"."Fax", "Site"."Email",
Dear all,
I upgraded my PostgreSQL installation using Redhat's RPM.
I believe the start up script in /etc/rc.d/init.d has not
been changed.
The postmaster seems to be running smoothly (psql session
works fine).
However when I try to connect to the database via Apache
with PHP, I get an errormessa
We have a weird problem.
When we try to update a table, we get this message
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hello all,
before you start reading, have in mind that this is not post to advertise
one db over another, I just want to know what happens, that's why I did
the comparisons with other db.
to the point:
This is my table:
Table "table1"
Attribute |Type | Modifier
--
I downloaded postgresql RPM 7.1.2 from postgresql.org, binary version built
for Redhat 6.2.
When installing the package rpm reports a dependency error, not finding
libssl.so.0 & libcrypto.so.0.
where can i find these two libraries? None of packages in RH 6.2 CD contains
that.
thank you.
---
If PostgreSQL is run on a system that has a file size limit (2 gig?), where
might cause us to hit the limit?
--
Naomi Walker
Chief Information Officer
Eldorado Computing, Inc.
602-604-3100 ext 242
---(end of broadcast)---
TIP 3: if posting/readi
Nicolas Kowalski wrote:
>
> Hello.
>
> We use PostgreSQL 7.1.2 on Debian GNU/Linux as our Intranet database. I
> am currently working on a small mailing-lists management application. I
> would like to enforce table access permissions depending on the current
> username :
>
> - if the current
Hi all...i'm trying to make a view i created in postgres editable...
I was trying with a rule like this one:
create rule test_rl as on
insert to my_view do instead
insert to my_real_table;
but it doesn't seem to work...
Basically i need that the whole view must be editable..
Thanks for your sug
Patrick Macdonald <[EMAIL PROTECTED]> wrote:
>
>I would like to take this opportunity to introduce myself
>and the Red Hat Database development team to the PostgreSQL
>community. We are pure engineering team (development,
>test and technical writing) based at the Red Hat Canada
>engineering of
Is it possible to run PostgreSQL in read-only mode?
For executing some maintenance procedures, I need to move database in
and out of the read-only mode
Is it possbile in PostgreSQl and if yes, how would I do it
Thanks in advance
---(end of broadcast)
Hello,
I'm looking for people in Belgium, who have any experience in working with
Databases, so we can exchange views and experiences. Do you know such people
(or maybe it's you), please contact me at [EMAIL PROTECTED] .
Greetings
Nico Vaes
---(end of broadcast)---
35 matches
Mail list logo
