ï
Are there any guidelines on how often one should do
a reindex?
- Original Message -
From:
Reece
Hart
To: scott.marlowe
Cc: pgsql-general
Sent: Thursday, November 13, 2003 12:50
PM
Subject: Re: [GENERAL] More Praise for
7.4RC2
On Thu, 2003-11-13 at 10:09,
Well, I have never seen any advantages in a package system... :)
As a developer, I like having full control of what I compile
BTJ
On Thu, 2003-11-13 at 20:45, Peter Eisentraut wrote:
> Bjørn T Johansen writes:
>
> > Just a question... Are there any reasons not to just take the source and
>
Bjørn T Johansen wrote:
Just a question... Are there any reasons not to just take the source and
compile it under RHEL 3.0? Or am I missing something?
(We are about to install 3.0, so I would really like to know..)
In fact there are some reasons *to* do this :
- compiler optimizations specific
Thanks Manuel,
It works nice!
Manuel Sugawara wrote:
Josué Maldonado <[EMAIL PROTECTED]> writes:
Hello list,
That's my question, I can't figure out a way to know if a given string is
digit, soemthing like this:
ISDIGIT("ARWA") = False
ISDIGIT("5334") = True
If anyone know a way to get t
I am trying to restore a file that I created using pg_dumpall.
I have searched the archives and the documentation. I know I am supposed to
use pg_restore but there is no example for restoring from a pg_dumpall file
(where the databases don't already exist).
How is it done? I think I have to speci
On Thu, 13 Nov 2003, jini us wrote:
>
> if libpq.dll contains the server and I can call the functions
> to start and stop programmatically.
> Then I could use Postgres as an embedded database sever in my application.
> That way I include libpq.dll in my software package for deployment
> with i
I have come to the conclusion that for my purpose
I would be better off using sqlite from www.sqlite.org
or firebird from www.phoenix.com.
Although mysql provides client APIs & server APIs
and is stable.
But there seems to be doubt whether mysql is actually
free if I wish to use it as an embedded
Martin Marques <[EMAIL PROTECTED]> writes:
> creating template1 database in /usr/local/pgsql/data/base/1... FATAL:
> semctl(1638435, 16, SETVAL, 536) failed: Argumento inválido
Hmm. If it got that far and no farther, I'd guess you have SEMVMX
set too small.
regards, tom
Thank you for your response.
I was looking for a FREE C++ Integrated development
The IDE suggested caters for linux/unix rather than
windows.
--- Dann Corbit <[EMAIL PROTECTED]> wrote: > >
-Original Message-
> > From: jini us [mailto:[EMAIL PROTECTED]
> > Sent: Friday, November 14, 200
On Thu, 2003-11-13 at 13:10, scott.marlowe wrote:
So, if your table is HIGHLY updated, you may need to run a plain vacuum
very often, and that's where the autovacuum daemon comes in handy. Just
set it to run every 30 minutes or so, and let it go. It should only
vacuum the tables that have
Are there settings in PostgreSQL to log SQL Statements from client apps?
Is yes, where are they logged to?
We set log_statement=On, but where does the log get sritten to?
Thanks,
Thomas LeBlanc
_
MSN Shopping upgraded for the holida
"Chris Stokes" <[EMAIL PROTECTED]> writes:
> PANIC: XLogWrite: write request 1/812D is past end of log 1/812D
This sure looks like the symptom of the 7.3.3 failure-to-restart bug.
If you are on 7.3.3 then an update to 7.3.4 will fix it.
regards, tom lane
I would class your solution as a work around
rather than a "natural solution".
Anyway I am using MS windows and to implement
postgres as embedded, using your approach, would
probably become complicated.
.It would probably introduce unwanted bugs in my
software.
--- Christopher Browne <[EMAIL
I was looking at the screen shots and the screen shots
do not show any features for GUI drag + drop
development.
Does it have a GUI drag + drop for drawing windows
components ?
--- "BARTKO, Zoltan" <[EMAIL PROTECTED]> wrote:
> Have you ever tried KDevelop (www.kdevelop.org)? it
> is part of KD
On Friday 14 November 2003 16:15, Thomas LeBlanc wrote:
> Are there settings in PostgreSQL to log SQL Statements from client apps?
>
> Is yes, where are they logged to?
>
> We set log_statement=On, but where does the log get sritten to?
Depends on how you start PG - you'll need to check your start
I am using the version 7.3.4
In some tables, I have serial to manage a unique
identifier.
As an example I have a column calld id_data as
a serial4.
I have in my tables 30 rows with id_data from 1 to
30
Then I delete rows with id 10 and 11.
Then I vaccum the table.
I create some new
> On Fri, 14 Nov 2003 10:01:51 -0500 (EST), <[EMAIL PROTECTED]>
> wrote:
>>The Production database is the "real" data, and we periodically take a
>> back up from Prod and re-instantiate QAT and DEV by dropping them and
>> then restoring from the Prod backup.
>
>> Not that OID's are in short supply
Hi,
I am looking for a database engine which:
1) runs under Windows (multiple versions)
2) Can be redistributed without additional fees as part of another product
Is postgresql appropriate for this?
If not, can you suggest a good alternative?
Thanks very much for your help.
Phil M.
---
[EMAIL PROTECTED] (Reece Hart) writes:
> On Thu, 2003-11-13 at 10:09, scott.marlowe wrote:
>
> Do you vacuum full every so often? If not, and if you've been overflowing
> your fsm, then your tables will just grow without shrinking.
> Also, index growth could be a problem.
>
> Hmm. I did
In article <[EMAIL PROTECTED]>,
Bruce Momjian <[EMAIL PROTECTED]> wrote:
>Yes, I noticed that we have a much longer view of our software lifecycle
>than most other open source projects.
I think the only other things comparable are the OSes themselves. The
Linux kernel and the releases of the var
[EMAIL PROTECTED] writes:
> Follow-up question: Are different ports really necessary?
Yes.
> I currently have the three different databases defined all in the same
> cluster, and differentiated by name, e.g., mydb, mydbqat, and mydbdev.
> If I have the postmaster start these three instances in s
On Wed, 12 Nov 2003 14:59:11 -0700 (MST)
[EMAIL PROTECTED] wrote:
>
> Are there hypertext pages available in 7.3 or 7.4 for
> SQL Key Words, like there are in SQL Commands, so a
> person can just click on the word and get documentation
> and usage information?
>
> I have looked on the website an
>
> If you're really concerned, you can initdb separate clusters for QAT
> and DEV and run three postmasters using three different ports.
>
Follow-up question: Are different ports really necessary? I currently
have the three different databases defined all in the same cluster, and
differentiated b
PostgreSQL is not intended to be embedded into other programs. You might
want to try SQLite, it's a free embeddable SQL engine:
http://go.jitbot.com/sqlite
regards
"jini us" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
>
> I am starting a new project where I intend to use
>
Did you see the FAQ item on estimating disk space?
---
Troels Arvin wrote:
> Hello,
>
> For some very data-intensive projects it's interesting how much space the
> DBMS uses for the storage of data, so I'm investigating how
Alex wrote:
Hi,
I have a couple of functions in my database (v7.3.4) and noticed that
after a certain period of time, the functions fail to work This happened
now serveal times and the function fail at different points. The did go
away when I restarted the postmaster. At one time the function a
In the last exciting episode, [EMAIL PROTECTED] (jini us) wrote:
> It is a shame that postgres is not available as an embedded server
> unlike mysql database server which comes in the form of a dll.
When the postmaster runs as a separate process, this has three major
merits:
1. It takes advanta
On Friday 14 November 2003 17:08, Thomas LeBlanc wrote:
> Where are the log files written?
Usually somewhere in /var/log/ but it depends on your startup script. If
you're on RedHat Linux and using the RPMs then your startup script is
/etc/init.d/postgresql and it seems to redirect to /dev/null (
[EMAIL PROTECTED] ("Rick Gigger") writes:
> Are there any guidelines on how often one should do a reindex?
When you discover that performance is "sucking" because of table
growth that would be fixed by a reindex. Unfortunately, there's not
quite a "quick prescription" for how to discover that :-(
On Nov 12, 2003, at 11:04 AM, Brett Maton wrote:
Hi NG,
How do I find out the size of a column ?
I am retrieving large objects from the pg_largeobject table and
creating a
files, I would like to know the length of the data column so that I can
implement buffering instead of writing hundreds
[EMAIL PROTECTED] (jini us) writes:
> So when the user starts my application I would start the database
> server, then stop it programmatically when the user stops using the
> application.
> I would obviously need some functionality so that I can programmatically
> configure which disk I would use
Hi,
I had the version 7.1 of postgresql running fine on Redhat 7.1.
Before upgrading my OS to RedHat 9, I forgot saying pgdump_all
- is there a way now to read the files stored with version 7.1
by using 7.3.4 without having to uninstall 7.3.4 and reinstall
7.1 just to say this command ?
Thanx in a
On Fri, Nov 14, 2003 at 18:24:16 +0100,
Guillaume Houssay <[EMAIL PROTECTED]> wrote:
> I am using the version 7.3.4
>
> In some tables, I have serial to manage a unique identifier.
>
> As an example I have a column calld id_data as a serial4.
>
> I have in my tables 30 rows with id_data from
Where are the log files written?
Thanks,
Thomas LeBlanc
From: Richard Huxton <[EMAIL PROTECTED]>
To: "Thomas LeBlanc" <[EMAIL PROTECTED]>,[EMAIL PROTECTED]
Subject: Re: [GENERAL] Loggin SQL Statements from JBOSS/JDBC
Date: Fri, 14 Nov 2003 17:07:37 +
On Friday 14 November 2003 16:15, Thomas L
On Fri, 14 Nov 2003 10:01:51 -0500 (EST), <[EMAIL PROTECTED]>
wrote:
>The Production database is the "real" data, and we periodically take a
>back up from Prod and re-instantiate QAT and DEV by dropping them and
>then restoring from the Prod backup.
> Not that OID's are in short supply,
>but I'm a
On Friday 14 November 2003 18:47, jini us wrote:
> I was looking at the screen shots and the screen shots
> do not show any features for GUI drag + drop
> development.
>
> Does it have a GUI drag + drop for drawing windows
> components ?
Yes. It has Qt designer which supports custom KDE widgets b
When running initdb on a fresh 7.4 install I get this error:
[EMAIL PROTECTED]:~$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data -E
latin1
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be
On 13/11/2003 19:32 Rick Gigger wrote:
Does anyone have any experience with postgres on fedora?
Fedora ships with 7.3.4. I've got it running nicely on a laptop.
HTH
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Softw
On Thu, 2003-11-13 at 10:01, Tom Lane wrote:
> Mark Harrison <[EMAIL PROTECTED]> writes:
> > Since these are all unique things, and will only be tested for
> > equality, I am guessing that making a hash index will be better
> > than making a btree index.
>
> You are mistaken. If there were any re
Hello!
> You can use the oid2name program in the contrib directory to kinda
> research which files are big under those trees and see if
> it's a table or
> index growth problem.
I found it a tedious operation, if you want to keep a check on growth of
your databases regularly. So I wrote a l
On Friday 14 November 2003 01:33, Rick Gigger wrote:
> Are there any guidelines on how often one should do a reindex?
Vacuum in 7.4 does take care of index bloat, much better than earlier
versions. So if you run autovacuum daemon with 7.4, then you can do away with
reindex.
Of course testing at
On Friday 14 November 2003 01:19, Bjørn T Johansen wrote:
> Well, I have never seen any advantages in a package system... :)
> As a developer, I like having full control of what I compile
>
>
> BTJ
>
> On Thu, 2003-11-13 at 20:45, Peter Eisentraut wrote:
> > Bjørn T Johansen writes:
> > > Just
I see that this is in fact documenated in the man page for pg_dumpall, when
I was looking at psql and pg_restore.
Thanks,
Hunter
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Have you ever tried KDevelop (www.kdevelop.org)? it is part of KDE
(www.kde.org), the newest version is going to be realesed very soon, but KDE
3.2 beta 1 was released already, get the tarballs from the above mentionned
address. I like it a lot, but you should check it out, if it suits your
needs.
On Thursday, November 13, 2003, at 08:04 PM, Peter Eisentraut wrote:
Use bytea. It stores bytes and allows the conversion into several
output
formats.
bytea with the binary or the hex? And isn't it a bit of a waste to add
the extra 4 bytes when I'll only ever need 16?
Thanks,
David
--
David
45 matches
Mail list logo
