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 sub
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
index
On Mon, Feb 28, 2011 at 11:26 AM, Josh Berkus 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 (pgsql-hackers@postgresql.
On Mon, Feb 28, 2011 at 10:49 AM, Josh Berkus 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
>> there's a mo
gin/master, master)
Author: Andrew Hammond
Date: Sat Feb 26 12:36:36 2011 -0800
simplify handling of mysql autoincrement to use serial8 datatype
commit 5c559b7073e6f6e72ce11f0f45be4d13cc30fd9a
Author: Andrew Hammond
Date: Sat Feb 26 12:26:46 2011 -0800
multi-value inserts are su
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. S
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 t
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 (har
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 wr
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
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 <[EMA
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/
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
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
>> deleti
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. Whic
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 pgsql
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 r
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
> > > functionali
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 ?
>
>
>
>
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 d
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
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
>> su
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.
> Lik
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 all
-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 flavor
-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
subs
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
ar
-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
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 launc
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 b
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 f
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:
> 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)
&
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 OPER
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 tha
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. T
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
, end_t
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
> o
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 the
On 3/12/07, Richard Huxton 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 specific addition
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 tab
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 K
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
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
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 n
> > 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 c
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-
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.
>
>
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
> > (lik
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 od
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.
>
> >>
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
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
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, wh
"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 mail
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 c
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 independ
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
> > "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
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
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
> 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
---
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 data
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 i
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:
> >
>
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 isencoded
> 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
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 a
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 bas
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 so...
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) mill
There seems to be some re-curring questions about how to manage
permissions across all objects in a database. Here's some tools to make
this kind of stuff easy. (documentation included in tarball)
--
Andrew Hammond416-673-4138[EMAIL PROTECTED]
Database Administrator, Afilias Canada
see any downsides to these changes?
|
| regards, tom lane
|
| ---(end of broadcast)---
| TIP 5: Have you checked our extensive FAQ?
|
|http://www.postgresql.org/docs/faqs/FAQ.html
- --
Andrew Hammond416-673-4
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.
---
lts
add the necessary 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 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 m
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
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
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.
Dre
83 matches
Mail list logo
