* Tom Lane <[EMAIL PROTECTED]> [010429 23:12] wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > big problem is that there is no good way to make the symlinks reliable
> > because in a crash, the symlink could point to a table creation that got
> > rolled back or the renaming of a table that g
Bruce Momjian <[EMAIL PROTECTED]> writes:
> big problem is that there is no good way to make the symlinks reliable
> because in a crash, the symlink could point to a table creation that got
> rolled back or the renaming of a table that got rolled back.
Yes. Have you already forgotten the very lo
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> I'm playing with wal parameters and found that wal_sync_method =
> open_sync enormously enhance the performance on my machine. Without it
> (using default fsync) I got only 90 tps at the best using pgbench (-s
> 2). However if I set wal_sync_method = open
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Ian Lance Taylor writes:
>> `make depend' is broken in the CVS sources.
> 'make depend' doesn't exist anymore. Use configure --enable-depend.
However, the makefiles are still full of depend targets --- so someone
who hadn't read the configure docs
On Mon, 30 Apr 2001, Tom Lane wrote:
> The Hermit Hacker <[EMAIL PROTECTED]> writes:
> > Okay, maybe this query isn't quite as simple as I think it is, but does
> > this raise any flags for anyone? How did I get into a COPY? It appears
> > re-creatable, as I've done it twice so far ...
>
> > ec
The Hermit Hacker <[EMAIL PROTECTED]> writes:
> Okay, maybe this query isn't quite as simple as I think it is, but does
> this raise any flags for anyone? How did I get into a COPY? It appears
> re-creatable, as I've done it twice so far ...
> eceb=# select e.idnumber,e.password from egi e, aut
Okay, maybe this query isn't quite as simple as I think it is, but does
this raise any flags for anyone? How did I get into a COPY? It appears
re-creatable, as I've done it twice so far ...
eceb=# select e.idnumber,e.password from egi e, auth_info a where e.idnumber !=
a.idnumber;
Backend sen
"Magnus Naeslund\(f\)" <[EMAIL PROTECTED]> writes:
> Where do get a listing of what PQftype() can return to me?
select oid, typname from pg_type
regards, tom lane
---(end of broadcast)---
TIP 3: if posting/reading through U
"Mikheev, Vadim" wrote:
>
> > > There's a report of startup recovery failure in Japan.
> > >
> > >> DEBUG: redo done at (1, 3923880100)
> > >> FATAL 2: XLogFlush: request is not satisfied
> > >> postmaster: Startup proc 4228 exited with status 512 - abort
> >
> > Is this person using 7.1 release
"G. Anthony Reina" <[EMAIL PROTECTED]> writes:
> I'm trying to use pg_dump to backup my tables one at a time from
> Postgres 7.0.3 (I'll upgrade to 7.1 in a few weeks). I'm getting a
> strange error that I've never encountered before.
> The error is : failed sanity check, table ro_ellipse was not
Here is what I suggested for oid2name to do with file names:
---
Just seems like a major pain; not worth the work.
If you do a ls and pipe it, here is what you would need to do:
- find out where $PWD is
- in that databas
If this isn't incorporated into a utility, it would certainly be prime
for inclusion for the yet-to-be-written chapter 11 of the PG Admin Manual
"Database Recovery."
Thanks for your responses, -Casey
The Hermit Hacker wrote:
> On Sun, 29 Apr 2001, Bruce Momjian wrote:
>
>
Yes, I like
> > I think parsing the file contents is too hard. The database would have
> > to be running and I would use psql.
>
> I don't know, I recovered someone's database using a "raw" connection ...
> wasn't that difficult once I figured out the format *shrug*
>
> the following gets the oid,relname's
> It certainly works quickly for smaller tables, however the 21.7 million
> record table I ran this on takes a touch longer as shown here:
>
> database=# explain select count(*) from table;
> NOTICE: QUERY PLAN:
>
> Aggregate (cost=478056.20..478056.20 rows=1 width=0)
>-> Seq Scan on tabl
- Original Message -
From: Alfred Perlstein <[EMAIL PROTECTED]>
To: Bruce Momjian <[EMAIL PROTECTED]>
Cc: The Hermit Hacker <[EMAIL PROTECTED]>; Casey Lyon <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Sunday, April 29, 2001 11:17 PM
Subject: Re: [HACKERS] Thanks, naming conventions, a
On Sun, 29 Apr 2001, Bruce Momjian wrote:
> > > Yes, I like that idea, but the problem is that it is hard to update just
> > > one table in the file. You sort of have to update the entire file each
> > > time a table changes. That is why I liked symlinks because they are
> > > per-table, but yo
Bruce Momjian wrote:
> The problem here is that now we don't have commit status in the index
> rows, so they have to check the heap for every row. One idea is to
> update the index status on an index scan, and if we can do that, we can
> easily use the index. However, the table scan is pretty
I could even see a utility that does a dump of this info into a flat file,
entirely overwriting the file every time.
This would be quick to reference and usable in a meltdown scenario. Could
easily be incorporated into vacuum and other db maintenance cron scripts.
-Casey
Bruce Momjian wrote:
> > Yes, I like that idea, but the problem is that it is hard to update just
> > one table in the file. You sort of have to update the entire file each
> > time a table changes. That is why I liked symlinks because they are
> > per-table, but you are right that the symlink creation could fail
>
2 points:
- I thought that a big part of the reason we got rid of filenames was
so we would use arbitrary table / db names that were not restricted by
the file system / OS. Using links would then return this restriction.
- What is the format for the table? Could we write a tool that can
read t
> * Bruce Momjian <[EMAIL PROTECTED]> [010429 20:14] wrote:
>
> > Yes, I like that idea, but the problem is that it is hard to update just
> > one table in the file. You sort of have to update the entire file each
> > time a table changes. That is why I liked symlinks because they are
> > per-t
On Sun, 29 Apr 2001, Bruce Momjian wrote:
> > I can even think of a situation, as unlikely as it can be, where this
> > could happen ... run out of inodes on the file system ... last inode used
> > by the table, no inode to stick the symlink onto ...
>
>
> If you run out of inodes, you are going
* Bruce Momjian <[EMAIL PROTECTED]> [010429 20:14] wrote:
> Yes, I like that idea, but the problem is that it is hard to update just
> one table in the file. You sort of have to update the entire file each
> time a table changes. That is why I liked symlinks because they are
> per-table, but yo
> I can even think of a situation, as unlikely as it can be, where this
> could happen ... run out of inodes on the file system ... last inode used
> by the table, no inode to stick the symlink onto ...
If you run out of inodes, you are going to have much bigger problems
than symlinks. Sort fil
On Sun, 29 Apr 2001, Bruce Momjian wrote:
> > I don't know the answers to these questions, which is why I'm asking them
> > ... if this is something safe to do, and doesn't break us again, then
> > sounds like a good idea to me too ...
>
> I was suggesting the symlinks purely for admin convenienc
> On Sun, 29 Apr 2001, Bruce Momjian wrote:
>
> > >
> > > doesn't this defeat the reasons for going to numerics? is there a reason
> > > why its such a difficult thing to do a SELECT oid on pg_database and
> > > pg_class to get this information? that's what I've been doing when I need
> > > to
On Sun, 29 Apr 2001, Bruce Momjian wrote:
> >
> > doesn't this defeat the reasons for going to numerics? is there a reason
> > why its such a difficult thing to do a SELECT oid on pg_database and
> > pg_class to get this information? that's what I've been doing when I need
> > to know *shrug*
>
> >
> > doesn't this defeat the reasons for going to numerics? is there a reason
> > why its such a difficult thing to do a SELECT oid on pg_database and
> > pg_class to get this information? that's what I've been doing when I need
> > to know *shrug*
>
> Yes, but you can't do that if you can'
>
> doesn't this defeat the reasons for going to numerics? is there a reason
> why its such a difficult thing to do a SELECT oid on pg_database and
> pg_class to get this information? that's what I've been doing when I need
> to know *shrug*
Yes, but you can't do that if you can't start the da
doesn't this defeat the reasons for going to numerics? is there a reason
why its such a difficult thing to do a SELECT oid on pg_database and
pg_class to get this information? that's what I've been doing when I need
to know *shrug*
On Sun, 29 Apr 2001, Bruce Momjian wrote:
> > First off I jus
> First off I just wanted to give a big 'thank you' to all the
> developers and contributors who have made PostgreSQL what it is
> today. I haven't come across a single thing since my first
> experience with it a few years ago that hasn't been corrected,
> sped up, or otherwise postively enhanced!
First off I just wanted to give a big 'thank you' to all the developers and
contributors
who have made PostgreSQL what it is today. I haven't come across a single thing
since my first experience with it a few years ago that hasn't been corrected, sped
up, or otherwise postively enhanced!
In work
> On Sat, Apr 28, 2001 at 06:45:39PM -0400, Bruce Momjian wrote:
> >
> > Sorry, only in 7.2. No new features in minor releases unless they are
> > very safe.
>
> So how was that patch not safe?
> It sure would make porting Oracle apps to PostgreSQL _much_ easier.
> How far dow
Here is a general call for people to review other open-source database
software and report back on things PostgreSQL can learn from them.
I can see Interbase, MySQL, and SAP DB as being three database that
would be worth researching. I am willing to assist anyone who wants to
give it a try. I h
* Bruce Momjian <[EMAIL PROTECTED]> [010429 10:44] wrote:
> > > I swore I'd never post to the hackers list again, but this is an amazing
> > > statement by Bruce.
> > >
> > > Boy, the robustness of the software is determined by the number of characters
> > > in the directory name?
> > >
> > > By
I see one of my mistakes here. The person clearly said "you have to
make it with SAP's proprietary build tools/environment." I didn't
realize you need the build tools/environment to meaningfully view the
code. Of course, as someone else stated, the build tools/environment
have been open-sourced
I have attached the original message and my reply. The person was
asking how we could used SAP "to see what postgres can learn". My reply
was to say that I couldn't figure how how to learn anything from the
code. That was my only statement.
I did not trash SAP DB. Seems using their developmen
> Have you considered that the development tools may
>
> be abstracting out the directory names in their development
> environment?
I never considered this, but it makes sense. I didn't try the
development tools and went right to the code. I did find a web site
that described the two-letter d
> > I swore I'd never post to the hackers list again, but this is an amazing
> > statement by Bruce.
> >
> > Boy, the robustness of the software is determined by the number of characters
> > in the directory name?
> >
> > By the languages used?
>
> [Snip]
>
> My guess is that Bruce was implyin
On Sat, Apr 28, 2001 at 06:45:39PM -0400, Bruce Momjian wrote:
>
> Sorry, only in 7.2. No new features in minor releases unless they are
> very safe.
So how was that patch not safe?
It sure would make porting Oracle apps to PostgreSQL _much_ easier.
How far down the line
Don Baccus wrote:
>
> Hi guys,
> >
> > I've used the open source SAPDB and the performance is pretty damned
> > impressive. However, 'open source' in application to it is somewhat
> > deceptive, since you have to make it with SAP's proprietary build
> > tools/environment.
> >
> > In my opinion, h
[ Charset ISO-8859-1 unsupported, converting... ]
> I found it myself:
Yes, this was on the Features web page.
> SQL Features
> - SQL 92 entry level with several extensions
> - Oracle 7 compatibility mode
Yes, that was a major feature to me. I just couldn't find it in the
code.
> - Updateabl
> You, or better someone who knows SAP DB could tell if it's "probably the most
> complete free database system available right now, with much more features
> than interbase, mysql or postgresql" as this guy Hemos says on Slashdot.
>
> I remember the same being said about Interbase when it was
> Bruce Momjian wrote: > > I downloaded it. The directories are
> two characters in length, the > files are numbers, and it is a
> mixture of C++, Python, and Pascal. Need > I say more. :-)
>
> OK, I'll bite: you need to say more.
>
> What is it like at handling transactions? What sort of f
Alastair D'Silva wrote:
>
> Hi guys (and girls),
>
> Firstly, I must say that everyone has been quite helpful to me while I've
> been migrating my database to PostgreSQL 7.1.
>
> One feature I would like to see would be the ability to set a "usage" and
> "idle" threshold, so that tables automat
Hi guys (and girls),
Firstly, I must say that everyone has been quite helpful to me while I've
been migrating my database to PostgreSQL 7.1.
One feature I would like to see would be the ability to set a "usage" and
"idle" threshold, so that tables automatically get vacuumed once they have
had mo
Thus spake special agent k
> I'm new to postgresql...but so far i love it...after working with companies
> that have spent millions of dollars on the big "O" i must say pgsql is a
> breath of fresh air...nice work to all who contributed.
>
> I'm looking at building a fault tolerant/failover d
> > BTW, I have not added cp1251.txt cp866.txt koi8-r.txt, since they
> > come from Unicode.org and are not permitted to re-distribute.
>
> It is not true for koi8-r.txt. At least one which is included into catdoc
> distribution I've made myself from RFC1483, and only afterward it has
> appear
Many thanks to you!!!
It now works (did'nt realize that strings where not null
terminated) stupid me!!!
Regards,
On Sat, 28 Apr 2001, mlw wrote:
> You actually almost have it right.
>
> You are passing VARDATA(user) to crypt, this is wrong.
>
> You must do something like this:
>
> int ulen =
Bruce Momjian wrote:
>
> I downloaded it. The directories are two characters in length, the
> files are numbers, and it is a mixture of C++, Python, and Pascal. Need
> I say more. :-)
OK, I'll bite: you need to say more.
What is it like at handling transactions? What sort of full-text index
I found it myself:
SQL Features
- SQL 92 entry level with several extensions
- Oracle 7 compatibility mode
Key benefits
- Referential integrity (to be defined in CREATE TABLE or ALTER Table
statement)
- Stored procedures
- After statement trigger (INSERT/UPDATE/DELETE)
- Updateable views, alt
Thanks for the fixes. I have committed your patches and they should
appear in 7.1.1.
BTW, I have not added cp1251.txt cp866.txt koi8-r.txt, since they
come from Unicode.org and are not permitted to re-distribute.
--
Tatsuo Ishii
From: Victor Wagner <[EMAIL PROTECTED]>
Subject: [PATCHES] Cyrill
> I downloaded it. The directories are two characters in length, the
> files are numbers, and it is a mixture of C++, Python, and Pascal. Need
> I say more. :-)
Yes!
You, or better someone who knows SAP DB could tell if it's "probably the most
complete free database system available right no
53 matches
Mail list logo
