I'm working on a tool that runs pg_restore with -j 4. I notice that
after COPYing in the data, pg_restore does two indexes and a cluster
command in parallel. The first CREATE INDEX is running, the CLUSTER
command is waiting on it and the second CREATE INDEX is waiting on the
CLUSTER. This seems
For a large table, should there be a difference in index sizes between a
single table representation and representation based on multiple partitions
with identical indexes?
A
I'm building some partitioning support functions. I'm working on writing one
called clone_indexes_to_partition right now. The idea is to take all the
indexes applied to the parent and create a matching index on the child. Is
there existing code that generates a CREATE INDEX statement given an
On Mon, Feb 28, 2011 at 11:26 AM, Josh Berkus j...@agliodbs.com wrote:
does foundry support git or should I just link to a repo on github?
If you prefer using git, the latter.
Ok, will do. Assign the project and I'll update stuff.
Andrew
--
Sent via pgsql-hackers mailing list
, master)
Author: Andrew Hammond andrew.george.hamm...@gmail.com
Date: Sat Feb 26 12:36:36 2011 -0800
simplify handling of mysql autoincrement to use serial8 datatype
commit 5c559b7073e6f6e72ce11f0f45be4d13cc30fd9a
Author: Andrew Hammond andrew.george.hamm...@gmail.com
Date: Sat Feb 26 12
On Mon, Feb 28, 2011 at 10:49 AM, Josh Berkus j...@agliodbs.com wrote:
Andrew,
I spent some time updating mysql2pgsql.perl. Changes were driven by an
attempt to migrate a redmine database. Original code was failing for a
number of reasons (regex recursion explosion, . I was wondering it
On Thu, Jul 3, 2008 at 10:57 PM, Andrew Hammond
[EMAIL PROTECTED] wrote:
On Thu, Jul 3, 2008 at 3:47 PM, Tom Lane [EMAIL PROTECTED] wrote:
Have you looked into the machine's kernel log to see if there is any
evidence of low-level distress (hardware or filesystem level)? I'm
wondering
On Mon, Jul 7, 2008 at 12:33 PM, Tom Lane [EMAIL PROTECTED] wrote:
Andrew Hammond [EMAIL PROTECTED] writes:
On Thu, Jul 3, 2008 at 3:47 PM, Tom Lane [EMAIL PROTECTED] wrote:
Have you looked into the machine's kernel log to see if there is any
evidence of low-level distress (hardware
On Mon, Jul 7, 2008 at 2:08 PM, Andrew Hammond
[EMAIL PROTECTED] wrote:
On Mon, Jul 7, 2008 at 12:33 PM, Tom Lane [EMAIL PROTECTED] wrote:
Also, I suggest filing a bug with your kernel distributor --- ENOSPC was
a totally misleading error code here. Seems like EIO would be more
appropriate
Does anyone else have any suggestions about what I can do to diagnose this?
Do I need to re-initdb or can I reasonably keep running with the existing db?
A
On Mon, Jun 30, 2008 at 7:20 PM, Andrew Hammond
[EMAIL PROTECTED] wrote:
On Fri, Jun 27, 2008 at 8:14 PM, Tom Lane [EMAIL PROTECTED] wrote
On Thu, Jul 3, 2008 at 2:35 PM, Tom Lane [EMAIL PROTECTED] wrote:
Andrew Hammond [EMAIL PROTECTED] writes:
Does anyone else have any suggestions about what I can do to diagnose this?
The whole thing is pretty mystifying, especially the ENOSPC write
failure on what seems like it couldn't have
On Thu, Jul 3, 2008 at 3:47 PM, Tom Lane [EMAIL PROTECTED] wrote:
Andrew Hammond [EMAIL PROTECTED] writes:
On Thu, Jul 3, 2008 at 2:35 PM, Tom Lane [EMAIL PROTECTED] wrote:
The whole thing is pretty mystifying, especially the ENOSPC write
failure on what seems like it couldn't have been a full
On Fri, Jun 27, 2008 at 8:14 PM, Tom Lane [EMAIL PROTECTED] wrote:
Andrew Hammond [EMAIL PROTECTED] writes:
(I thought this line was interesting)
Jun 27 15:54:31 qadb2 postgres[92519]: [44-1] PANIC: could not open
relation 1663/16386/679439393: No such file or directory
I googled to find
On Wed, Jun 25, 2008 at 9:57 AM, Andrew Hammond
[EMAIL PROTECTED] wrote:
On Wed, Jun 25, 2008 at 2:58 AM, Heikki Linnakangas [EMAIL PROTECTED] wrote:
Andrew Hammond wrote:
I found this error message in my log files repeatedly:
Error: failed to re-find parent key
I found this error message in my log files repeatedly:
Error: failed to re-find parent key in ledgerdetail_2008_03_idx2 for
deletion target page 64767
I though hmm, that index looks broken. I'd better re-create it. So, I
dropped the index and then tried to create a new one to replace it. Which
On Wed, Jun 25, 2008 at 2:58 AM, Heikki Linnakangas [EMAIL PROTECTED]
wrote:
Andrew Hammond wrote:
I found this error message in my log files repeatedly:
Error: failed to re-find parent key in ledgerdetail_2008_03_idx2 for
deletion target page 64767
I though hmm, that index looks broken
I'd confirmation on how WAL files are named. I'm trying to write a tool
which can tell me when we are missing a WAL file from the sequence. I
initially thought that the file names were monotonically incrementing
hexadecimal numbers. This doesn't appear to be the case.
000101B700FD
On Dec 12, 2007 11:37 AM, Alvaro Herrera [EMAIL PROTECTED] wrote:
Joshua D. Drake wrote:
test
Does anybody see any value in having [EMAIL PROTECTED] be an alias
for pgsql-hackers?
No, but I see some mild irritation in having to modify my rules to tag a
second address with the
On Nov 29, 2007 11:11 AM, Ron Mayer [EMAIL PROTECTED] wrote:
Robert Treat wrote:
On Tuesday 27 November 2007 15:07, Simon Riggs wrote:
On Tue, 2007-11-27 at 14:02 -0500, Tom Lane wrote:
There has been some discussion of making a project policy of dropping
support for old releases after
On 10/11/07, Bruce Momjian [EMAIL PROTECTED] wrote:
Kevin Grittner wrote:
On Thu, Oct 11, 2007 at 3:04 PM, in message
[EMAIL PROTECTED], Bruce Momjian [EMAIL PROTECTED]
wrote:
This release represents a major leap forward by adding significant new
functionality and performance
Wrong list. Try asking on the pgAdmin3 list, or maybe pgsql-general.
Andrew
On 9/16/07, Eretna Evrengizid [EMAIL PROTECTED] wrote:
hi,
I use postgresql 8.2 and I cant see database diagram on pgAdmin III, I
think it can be . it is there , isnt it ?
--
Be
On 9/13/07, Bruce Momjian [EMAIL PROTECTED] wrote:
Alvaro Herrera wrote:
Bruce Momjian wrote:
Is this item closed?
No, it isn't. Please add a TODO item about it:
* Prevent long-lived temp tables from causing frozen-Xid advancement
starvation
Sorry, I don't understand this.
On 8/7/07, Tom Lane [EMAIL PROTECTED] wrote:
Peter Eisentraut [EMAIL PROTECTED] writes:
But INFO is not shown by default.
INFO is mostly a hack to try to emulate VACUUM VERBOSE's ancient
behavior before we redesigned the elog levels. It's intended for
controlling messages that should go
On 6/25/07, Tom Lane [EMAIL PROTECTED] wrote:
Andrew Hammond [EMAIL PROTECTED] writes:
On 6/25/07, Tom Lane [EMAIL PROTECTED] wrote:
The normal build process for any open-source package is
./configure
make
sudo make install
... now what? OK, time to read the manual ...
Since
On 6/25/07, Tom Lane [EMAIL PROTECTED] wrote:
Andrew Sullivan [EMAIL PROTECTED] writes:
On Mon, Jun 25, 2007 at 01:31:52PM -0400, Tom Lane wrote:
Why is that better than the initdb-time option we already have?
Locking down options earlier rather than later is usually not a win.
Like I said,
The problem here is that there aren't really very many defined
defaults, or that these defaults vary (sometimes greatly) between the
different flavors of UNIX. For example, please tell me:
1) Where should PGDATA default to?
2) How do you want to handle logging output from the postmaster? There
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 6/12/07, Tom Lane wrote:
A more serious objection is that any automated tool would probably get it
wrong sometimes, and strip important text.
I vote 'lets not bother'
Right. I agree with Josh's idea about mentioning list policies in the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 6/12/07, Andrej Ricnik-Bay wrote:
On 6/13/07, Andrew Hammond wrote:
The problem here is that there aren't really very many defined
defaults, or that these defaults vary (sometimes greatly) between the
different flavors of UNIX. For example
On 6/12/07, Josh Berkus [EMAIL PROTECTED] wrote:
Tom,
What's the point? You keep reminding us that your code is middleware
that can't assume anything much about the queries you're dealing with.
Therefore, I see no real value in fixing up one corner case. Your
argument about space
On 6/7/07, Jim C. Nasby [EMAIL PROTECTED] wrote:
On Mon, Jun 04, 2007 at 11:04:26AM -0400, Alvaro Herrera wrote:
The launcher is set up to wake up in autovacuum_naptime seconds at most.
So if the user configures a ridiculuos time (for example 86400 seconds,
which I've seen) then the launcher
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 6/7/07, Matthew T. O'Connor wrote:
Tom Lane wrote:
Andrew Hammond writes:
Hmmm... it seems to me that points new users towards not using
autovacuum, which doesn't seem like the best idea. I think it'd be
better to say that setting
On Jun 5, 9:19 am, [EMAIL PROTECTED] (Alvaro Herrera) wrote:
Zdenek Kotala wrote:
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Is this a TODO?
I don't think so; there is no demand from anybody but Zdenek to remove
those programs. Has it ever even come up before?
On 5/18/07, Andrew Hammond [EMAIL PROTECTED] wrote:
On 5/17/07, Tom Lane [EMAIL PROTECTED] wrote:
Andrew Hammond [EMAIL PROTECTED] writes:
On 5/17/07, Tom Lane [EMAIL PROTECTED] wrote:
What are the grounds for defining it that way rather than some other
way?
The only alternative
On 5/17/07, Tom Lane [EMAIL PROTECTED] wrote:
Andrew Hammond [EMAIL PROTECTED] writes:
On 5/17/07, Tom Lane [EMAIL PROTECTED] wrote:
What are the grounds for defining it that way rather than some other
way?
The only alternative that came to mind when I wrote it was using a
numeric
instead
Yet another potential addition to the family of operators. Some guy
was asking for it on IRC so...
CREATE OR REPLACE FUNCTION interval_over_interval(interval, interval)
RETURNS float STRICT IMMUTABLE LANGUAGE sql AS $$
SELECT extract(epoch from $1)::float / extract(epoch from $2);
$$;
CREATE
On 5/17/07, Tom Lane [EMAIL PROTECTED] wrote:
Andrew Hammond [EMAIL PROTECTED] writes:
Yet another potential addition to the family of operators. Some guy
was asking for it on IRC so...
CREATE OR REPLACE FUNCTION interval_over_interval(interval, interval)
RETURNS float STRICT IMMUTABLE
On May 11, 1:16 pm, Erik 2.0 [EMAIL PROTECTED] wrote:
Is pg_comparator the only project out there that does what it does? I
tried patching it, and it seems OK, but I'm not terribly confident in
my patch. I'm hoping someone will tell me there's a great table-
driven rsync out there that
On May 8, 7:16 am, [EMAIL PROTECTED] (Abraham, Danny) wrote:
Hi,
I am migrating from Sybase to Postgres.
3. Who is the guy to ask about a feature like startup migrate in ORACLE?
You could check out EnterpriseDB, which is based on Postgres and
provides an Oracle compatibility layer. That
If you have a table with a bunch of children, and these children all
have a primary key which is generated from the same sequence, assuming
that you're partitioning based on date (ie, this is a transaction
record table), it would be nice if the planner could spot that all
tables have a primary key
I've written the following function definitions to extend
generate_series to support some temporal types (timestamptz, date and
time). Please include them if there's sufficient perceived need or
value.
-- timestamptz version
CREATE OR REPLACE FUNCTION generate_series
( start_ts timestamptz
,
On Apr 3, 5:37 pm, [EMAIL PROTECTED] (4wheels) wrote:
Hello all!
This is my first post! I am interested in finding out what queries have
been made against a particular database in postgres. The version of Postgres
is 8.0 running on Mandrake 10. The queries are made by client computers
over
1) Wrong list, you want -hackers.
2) Did you have a specific question based on what you have read or are
you asking for suggested reading?
On 3/29/07, 李宁 [EMAIL PROTECTED] wrote:
Dear everyone,
I'm a college student,now I am doing the topic about the postgresql storage
management as my
On Mar 11, 12:47 pm, [EMAIL PROTECTED] (Josh Berkus) wrote:
No matter how much Heikki hates them, I think he'd agree that EAV tables are
better than having the application execute DDL at runtime.
EAV moves the structure that is typically in the design of the tables
into the contents of the
On 3/12/07, Richard Huxton dev@archonet.com wrote:
Josh Berkus wrote:
I really don't see any way you could implement UDFs other than EAV that
wouldn't be immensely awkward, or result in executing DDL at runtime.
What's so horrible about DDL at runtime? Obviously, you're only going to
allow
On Feb 25, 9:34 am, [EMAIL PROTECTED] (Andrew Dunstan) wrote:
Phani Kishore wrote:
hi !
i think u people could probably help me i how to query the
pgsql/postgis from google maps api to display the markers on the
google maps which are stored in the postgis database.
Phani Kishore
On Feb 22, 9:49 am, [EMAIL PROTECTED] (Alvaro Herrera) wrote:
Andrew Dunstan wrote:
It's also fair to say that this is a subject about which we usually get
much more noise from partisans of other SCM systems than from the
relatively small number of people who actually have to maintain the
On Feb 18, 9:35 am, [EMAIL PROTECTED] (Tom Lane) wrote:
Russell Smith [EMAIL PROTECTED] writes:
If you replan and immutable function, aren't you possibly messing up a
functional index that is using the old function. Hey, if you change an
immutable function that has an index, you are in
On Feb 12, 5:16 pm, [EMAIL PROTECTED] (Joshua D. Drake) wrote:
Peter Eisentraut wrote:
Jeroen T. Vermeulen wrote:
Is this a known problem? Is there any test procedure that builds the
base distribution before release?
Most of the core team is convinced that the postgresql-foo tarballs
The FreeBSD database/postgres* ports depend on them. Which is probably
why Marc insists on keeping them.
Well, I think that's a horrid dependency to have. Other packaging
systems (e.g. the RPM builds) seem quite able to split up a single
unified build into multiple packages - what can't
On 2/13/07, Peter Eisentraut [EMAIL PROTECTED] wrote:
Andrew Hammond wrote:
The FreeBSD database/postgres* ports depend on them. Which is
probably why Marc insists on keeping them.
I hesitate to believe that seeing that they don't actually work, whereas
we have heard no complaints
On Feb 7, 8:12 pm, [EMAIL PROTECTED] (Bruce Momjian) wrote:
Jan Wieck wrote:
On 2/7/2007 10:35 PM, Bruce Momjian wrote:
I find the term logical proof of it's correctness too restrictive. It
sounds like some formal academic process that really doesn't work well
for us.
Thank you.
On Jan 19 2006, 9:36 pm, [EMAIL PROTECTED] (Larry Rosenman) wrote:
Tom Lane wrote:
Larry Rosenman [EMAIL PROTECTED] writes:
I've got a fastFreeBSD/amd64 server available to run Buildfarm
on.
However, I see we already have a couple of others running it.
My questions are:
I'm trying to build PostgreSQL 8.2.2 outside the ports system on a
FreeBSD 6.2 amd64 box. The databases/postgresql81-server port builds
8.1.7 just fine on the same box. My configure fails. I'm new to
FreeBSD so I expect I'm missing something pretty obvious. config.log
follows. Line 2212 is very
On Feb 8, 11:28 am, [EMAIL PROTECTED] (Alvaro Herrera) wrote:
Tom Lane wrote:
I thought it might be coming from your --with-libs switch somehow,
but when I add that to my configure command it does not change this
output at all. Is it possible you've got environment variables
(like
On 2/6/07, Jim Nasby [EMAIL PROTECTED] wrote:
On Feb 5, 2007, at 12:53 PM, Andrew Hammond wrote:
On Jan 26, 2:38 pm, [EMAIL PROTECTED] (Tom Lane) wrote:
Rick Gigger [EMAIL PROTECTED] writes:
I thought that the following todo item just barely missed 8.2:
Allow a warm standby system to also
On Jan 26, 2:38 pm, [EMAIL PROTECTED] (Tom Lane) wrote:
Rick Gigger [EMAIL PROTECTED] writes:
I thought that the following todo item just barely missed 8.2:
Allow a warm standby system to also allow read-only statements [pitr]
No, it's a someday-wishlist item; the work involved is not
Benny Amorsen wrote:
TL == Tom Lane [EMAIL PROTECTED] writes:
TL Anyone against making it case-insensitive, speak now or hold your
TL peace.
SI-units are inherently case-sensitive. The obvious example is that
now you will allow people to specify an amount in millibytes, while
interpreting
Indira Muthuswamy wrote:
Can anyone of you help me in finding the datatype of a particular column in
a table in Postgres?
Thanks and Regards,
M.Indira
You're almost in the right place, but you'd be better off asking this
question in the pgsql-general or perhaps pgsql-novice. This mailing
1) This has nothing to do with hacking the internals of Postgres, which
means you are asking on the wrong list.
2) This has little to do with the Postgres scripts, but instead has to
do with the bootup scripts for the OS and or possibly some HP-UX
package manager. It is unlikely that the Postgres
Kenneth Marshall wrote:
RT is easy to setup/configure/use and works well with PostgreSQL
as the backend.
RT works with Postgres, but I wouldn't say well. All queries in RT are
generated by a query generator due to a naive obsession with database
independance. They've achieved database
I need to write a perl module which will parse a .pgpass file into a
reasonable data-structure in memory. I may extend it later to go in the
other direction (given a populated datastructure, write a .pgpass).
The first question that came to mind is what namespace should I put
this under? Is there
I am actually hoping that jabber.postgresql.org would help that in the
long run.
Jabber's ok, but why not go with SILC instead?
---(end of broadcast)---
TIP 6: explain analyze is your friend
Markus Schiltknecht wrote:
Hi,
Andrew Hammond wrote:
I can see value in documenting what replication systems are known to
work (for some definition of work) with a given release in the
documentation for that release. Five years down the road when I'm
trying to implement replication
There are a number of different approaches to solving the problem of
replication, each with strengths and weaknesses. As a result, there
are a number of different replication solutions available for
PostgreSQL. To find out more, please refer to the website.
Well, that's what I've been
Peter Eisentraut wrote:
Alvaro Herrera wrote:
I don't think this sort of material belongs directly into the
PostgreSQL documentation.
Why not?
PostgreSQL documentation (or any product documentation) should be
factual: describe what the software does and give advice on its use.
This
I am a PostgreSQL lover at China, I'd like to know when the column-level
privilege can be added to a release version of PostgreSQL? and is there
someone who is working on the problem?
You can often achieve similar effects with VIEWs and RULEs / TRIGGERs.
Drew
Neil Conway wrote:
I would suggest starting with utility functions like index builds or COPY
which would have to be specially handled anyways. Handling all optimizable
queries in a single generic implementation seems like something to tackle
only
once the basic infrastructure is there
I posted about this a couple of days ago, but the post was not
complete. Trying again:
-- suppose the following table exists
CREATE TABLE many_tables (
table_id text, -- defines which virtual table encoded
att0 text,
att1 text,
att2 text,
att3 text
);
-- with some example
I have a client with the following EAV inspired schema.
CREATE TABLE many_tables (
table_id text primary key,-- defines which virtual table is
encoded
attribute1 text,
attribute2 text,
attribute3 text,
attribute4 text,
...
);
I'd like to use a mix of constraint
Thomas Bley wrote:
I type: pg_dump -h localhost -U postgres database_name and there is no
question for the password.
Have you created a .pgpass (or whatever the equivilant in the Windows
world is)? That could be supplying the password.
I haven't made changes to pg_hba.conf. I'm logged in as
There is a pgpass file and it contians the password:
D:\Documents and Settings\admin\Application Data\postgresql\pgpass.conf
My installation is on: D:\Program Files\PostgreSQL\8.1\
Maybe it got automatically created by pgadmin3 ?
I'll bet you're right.
Looking into the documentation
On 7/18/06, Aaron Bono [EMAIL PROTECTED] wrote:
On 18 Jul 2006 09:07:08 -0700, Andrew Hammond
[EMAIL PROTECTED] wrote:
I have a client with the following EAV inspired schema.CREATE TABLE many_tables (table_id text primary key,-- defines which virtual table isencodedattribute1 text,attribute2
Hannu Krosing wrote:
Ühel kenal päeval, T, 2006-07-18 kell 16:44, kirjutas Andrew Hammond:
On 7/18/06, Aaron Bono [EMAIL PROTECTED] wrote:
On 18 Jul 2006 09:07:08 -0700, Andrew Hammond
[EMAIL PROTECTED] wrote:
I have a client with the following EAV
Is there any interest in a basic perl script that would read through a
postgresql.conf file and calculate approximate memory (and shared
memory) usage? Also, are there any other (simple for now) things I
should look at in the process? Asking because I'm getting annoyed with
doing this by hand
How much work would it be to implement and how valuable would people
find the following additions to pg_stat_activity?
1) # of transactions committed on this connection since start
2) # of transactions rolled back
3) milliseconds used processing requests
4) milliseconds idle in transaction
5)
)---
| TIP 5: Have you checked our extensive FAQ?
|
|http://www.postgresql.org/docs/faqs/FAQ.html
- --
Andrew Hammond416-673-4138[EMAIL PROTECTED]
Database Administrator, Afilias Canada Corp.
CB83 2838 4B67 D40F D086 3568 81FC E7E5 27AF 4A9A
-BEGIN PGP
Christopher Browne wrote:
After takin a swig o' Arrakan spice grog, Anonymous [EMAIL PROTECTED] belched out:
Does anybody here know how to hack into a mysql database?
You might want to visit a mailing list devoted to MySQL; they might
know...
And possibly even care, too.
index, ANALYZE then EXPLAIN ANALYZE.
so my question remains as it is that is there any such thing which can
be called at startup of psql.to make connection to database
I'm really not sure what you mean by this. psql connects to the database
on startup.
regards
Vinay
Andrew Hammond wrote
Vinay Jain wrote:
Hi
thank you for such a useful information...
but actually in my case if i keep table in disk it significantly
degrades performance and even for a table of 10 rows it takes 1-2
minutes I think u r not beliving it ! am i right
for example
I create a table in which i use
Mark Kirkwood wrote:
Tom Lane wrote:
I think if you spelled the subdir name config rather than etc,
it would be more obvious what's what.
How about 'conf' - (familiar to anyone who has used apache or tomcat )
How about 'etc' - (familiar ot anyone who has used unix)
--
Andrew Hammond
Tom Lane wrote:
Andrew Hammond [EMAIL PROTECTED] writes:
I've attached a patch for pg_ctl which integrates the Apache project's
rotatelogs for logging.
Why bother? You just pipe pg_ctl's output to rotatelogs and you're
done.
It's not difficult to do, once you know how and once you know
I've attached a patch for pg_ctl which integrates the Apache project's
rotatelogs for logging. Is there any interested in the community for
such a thing? I have not yet added the appropriate stuff to autoconf to
completely integrate this.
I would appreciate any suggestions for improvement.
82 matches
Mail list logo
