Re: [HACKERS] unique index violation after pg_upgrade to PG10

2017-10-24 Thread Justin Pryzby
On Tue, Oct 24, 2017 at 02:57:47PM -0700, Peter Geoghegan wrote: > On Tue, Oct 24, 2017 at 1:11 PM, Justin Pryzby <pry...@telsasoft.com> wrote: > > ..which I gather just verifies that the index is corrupt, not sure if > > there's > > anything else to do with it?

Re: [HACKERS] unique index violation after pg_upgrade to PG10

2017-10-24 Thread Justin Pryzby
On Tue, Oct 24, 2017 at 02:57:47PM -0700, Peter Geoghegan wrote: > On Tue, Oct 24, 2017 at 1:11 PM, Justin Pryzby <pry...@telsasoft.com> wrote: > > ..which I gather just verifies that the index is corrupt, not sure if > > there's > > anything else to do with it?

Re: [HACKERS] unique index violation after pg_upgrade to PG10

2017-10-24 Thread Justin Pryzby
ugh a duplicate row > existed. Then the next pg_repack would fail with the error you got. FTR, I was able to run the repack script several times without issue, hitting that table each time. Justin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to y

Re: [HACKERS] unique index violation after pg_upgrade to PG10

2017-10-24 Thread Justin Pryzby
The CSV logs clearly show that our application INSERTed > >> rows > >> which are duplicates. > >> > >> [pryzbyj@database ~]$ rpm -qa pg_repack10 > >> pg_repack10-1.4.2-1.rhel6.x86_64 > >> > >> Justin > > > > Hi Justin

Re: [HACKERS] unique index violation after pg_upgrade to PG10

2017-10-24 Thread Justin Pryzby
On Tue, Oct 24, 2017 at 01:27:14PM -0500, Kenneth Marshall wrote: > On Tue, Oct 24, 2017 at 01:14:53PM -0500, Justin Pryzby wrote: > > Note: > > I run a script which does various combinations of ANALYZE/VACUUM > > (FULL/ANALYZE) > > following the upgrade, and a scrip

[HACKERS] unique index violation after pg_upgrade to PG10

2017-10-24 Thread Justin Pryzby
P410i controller SSDSmartPathCap- En- Exp=1 sites is perhaps our most central table and I would expect issues there to be quickly apparent (however this was at least initially a silent failure). public | sites | table | telsasoft | 80 kB | Justin -- Sent via pgsq

[HACKERS] per-sesson errors after interrupting CLUSTER pg_attrdef

2017-10-19 Thread Justin Pryzby
This was briefly scary but seems to have been limited to my psql session (no other errors logged). Issue with catcache (?) I realized that the backup job I'd kicked off was precluding the CLUSTER from running, but that CLUSTER was still holding lock and stalling everything else under the sun.

Re: [HACKERS] [GENERAL] huge RAM use in multi-command ALTER of table heirarchy

2017-10-18 Thread Justin Pryzby
postmaster) total-vm:13544792kB, anon-rss:8977764kB, file-rss:8kB So I'm hoping to encourage someone to commit the change contemplated earlier. Thanks in advance. Justin On Tue, Jul 18, 2017 at 07:26:30PM -0400, Tom Lane wrote: > Justin Pryzby <pry...@telsasoft.com> writes: > > I'

Re: [HACKERS] SIGSEGV in BRIN autosummarize

2017-10-18 Thread Justin Pryzby
16400 | gtt 13457 | postgres 1 | template1 The gtt DB is where the (only) BRIN indicies are (not sure what to conclude from that?) Justin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] SIGSEGV in BRIN autosummarize

2017-10-18 Thread Justin Pryzby
On Wed, Oct 18, 2017 at 06:54:09PM +0200, Alvaro Herrera wrote: > Justin Pryzby wrote: > > > No crashes in ~28hr. It occurs to me that it's a weaker test due to not > > preserving most compilation options. > > And the previous code crashes in 45 minutes? That's sol

Re: [HACKERS] SIGSEGV in BRIN autosummarize

2017-10-18 Thread Justin Pryzby
On Tue, Oct 17, 2017 at 09:07:40AM -0500, Justin Pryzby wrote: > On Tue, Oct 17, 2017 at 09:34:24AM -0400, Tom Lane wrote: > > Justin Pryzby <pry...@telsasoft.com> writes: > > > On Tue, Oct 17, 2017 at 12:59:16PM +0200, Alvaro Herrera wrote: > > >&g

Re: [HACKERS] SIGSEGV in BRIN autosummarize

2017-10-17 Thread Justin Pryzby
On Tue, Oct 17, 2017 at 09:34:24AM -0400, Tom Lane wrote: > Justin Pryzby <pry...@telsasoft.com> writes: > > On Tue, Oct 17, 2017 at 12:59:16PM +0200, Alvaro Herrera wrote: > >> Anyway, can give this patch a try? > > > I've only compiled postgres once before and

Re: [HACKERS] SIGSEGV in BRIN autosummarize

2017-10-17 Thread Justin Pryzby
On Tue, Oct 17, 2017 at 12:59:16PM +0200, Alvaro Herrera wrote: > Justin Pryzby wrote: > > > #1 0x006a52e9 in perform_work_item (workitem=0x7f8ad1f94824) at > > autovacuum.c:2676 > > cur_datname = 0x298c740 "no 1 :vartype 1184 :vartypmod -1 &g

Re: [HACKERS] SIGSEGV in BRIN autosummarize

2017-10-17 Thread Justin Pryzby
res tarball, apply the patch, and run the compiled postgres binary from the source tree, without running make install or similar ? Otherwise, would it be good enough to copy the postgres binary to /usr/pgsql-10/bin (and reinstall the binary package later) ? Thanks, Justin -- Sent via pgsql-hack

Re: [HACKERS] SIGSEGV in BRIN autosummarize

2017-10-17 Thread Justin Pryzby
On Sun, Oct 15, 2017 at 02:44:58PM +0200, Tomas Vondra wrote: > Thanks, but I'm not sure that'll help, at this point. We already know > what happened (corrupted memory), we don't know "how". And core files > are mostly just "snapshots" so are not very useful in answering that :-( Is there

Re: [HACKERS] SIGSEGV in BRIN autosummarize

2017-10-15 Thread Justin Pryzby
On Sat, Oct 14, 2017 at 08:56:56PM -0500, Justin Pryzby wrote: > On Fri, Oct 13, 2017 at 10:57:32PM -0500, Justin Pryzby wrote: > > > Also notice the vacuum process was interrupted, same as yesterday (think > > > goodness for full logs). Our INSERT s

Re: [HACKERS] SIGSEGV in BRIN autosummarize

2017-10-14 Thread Justin Pryzby
On Fri, Oct 13, 2017 at 10:57:32PM -0500, Justin Pryzby wrote: > > Also notice the vacuum process was interrupted, same as yesterday (think > > goodness for full logs). Our INSERT script is using python > > multiprocessing.pool() with "maxtasksperchild=1", which I thin

Re: [HACKERS] SIGSEGV in BRIN autosummarize

2017-10-14 Thread Justin Pryzby
On Fri, Oct 13, 2017 at 10:57:32PM -0500, Justin Pryzby wrote: > I don't have any reason to believe there's memory issue on the server, So I > suppose this is just a "heads up" to early adopters until/in case it happens > again and I can at least provide a stack trace. I'm ba

[HACKERS] SIGSEGV in BRIN autosummarize

2017-10-13 Thread Justin Pryzby
n and I can at least provide a stack trace. Justin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] memory fields from getrusage()

2017-09-01 Thread Justin Pryzby
On Sat, Sep 02, 2017 at 02:00:44PM +1200, Thomas Munro wrote: > On Sat, Sep 2, 2017 at 7:46 AM, Peter Eisentraut > <peter.eisentr...@2ndquadrant.com> wrote: > > On 6/15/17 10:58, Justin Pryzby wrote: > >> On Thu, Jun 15, 2017 at 10:29:21AM -0400, Robert Haas wrote: >

Re: [HACKERS] Possible issue with expanded object infrastructure on Postgres 9.6.1

2017-08-09 Thread Justin Workman
egards, tom lane > $customer, here. I just want to thank everyone involved for getting to the bottom of this and for your support. Even if it missed the 9.6.4 release, I'm very grateful for your help. We haven't had much of an issue since disabling parallel workers so nothing is harmed by waiting a little longer. Thanks, Justin

[HACKERS] PG10b2: column-list UPDATE syntax fails with single column

2017-07-19 Thread Justin Pryzby
in the middle of changing it), but wondered if it was intentional or otherwise if the release notes should mention that old syntax is no longer accepted. Either way - thanks in advance. Justin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

[HACKERS] tupconvert.c API change in v10 release notes

2017-07-19 Thread Justin Pryzby
, | let's remember to mention it in the v10 release notes.) ..but couldn't see that the commit or change is so referenced. Justin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] memory fields from getrusage()

2017-06-15 Thread Justin Pryzby
On Thu, Jun 15, 2017 at 10:29:21AM -0400, Robert Haas wrote: > On Wed, Jun 14, 2017 at 6:28 PM, Justin Pryzby <pry...@telsasoft.com> wrote: > > On Tue, Jun 13, 2017 at 12:16:00PM -0400, Robert Haas wrote: > >> It might be worth adding platform-specific code for common platf

Re: [HACKERS] memory fields from getrusage()

2017-06-14 Thread Justin Pryzby
d unshared data, %ld unshared stack (kB)\n", r.ru_maxrss, r.ru_ixrss, r.ru_idrss, r.ru_isrss); #elif defined(__darwin__) appendStringInfo(, "!\t%ld max resident, %ld shared, %ld unshared data, %ld unshared stack (kB)\n", r.ru_maxrss/1024, r.ru_ixrss/1024, r.ru_id

[HACKERS] memory fields from getrusage()

2017-06-10 Thread Justin Pryzby
) the case for supported platforms? I'm hoping that in 2017 one can just call getrusage() if autoconf says it's okay ?? Justin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Possible issue with expanded object infrastructure on Postgres 9.6.1

2017-02-16 Thread Justin Workman
y, just to narrow down where the problem lies. > regards, tom lane Hi Tom, My name is Justin, and I am $customer as it were. As Peter explained, we haven't seen the segfaults anymore since disabling parallel queries. This works as a quick fix and is much appreciated! If you would still like to get

[HACKERS] smallint out of range EXECUTEing prepared statement

2017-01-18 Thread Justin Pryzby
(32768); (0 rows) Note, we also sometimes get small/int out of range when SELECTing from a view, and we end up as a workaround putting a ::big/int cast into the view or multiplying by 1. Thanks, Justin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] ALTER TABLE .. ALTER COLUMN .. ERROR: attribute .. has wrong type

2017-01-03 Thread Justin Pryzby
On Tue, Jan 03, 2017 at 03:35:34PM -0500, Tom Lane wrote: > Justin Pryzby <pry...@telsasoft.com> writes: > > On Tue, Jan 03, 2017 at 03:18:15PM -0500, Tom Lane wrote: > >> I'm wondering if this represents some sort of out-of-sync condition > >> between the tabl

Re: [HACKERS] ALTER TABLE .. ALTER COLUMN .. ERROR: attribute .. has wrong type

2017-01-03 Thread Justin Pryzby
On Tue, Jan 03, 2017 at 03:18:15PM -0500, Tom Lane wrote: > Justin Pryzby <pry...@telsasoft.com> writes: > > (gdb) bt > > #3 0x0059d5ce in ATRewriteTable (tab=, > > OIDNewHeap=, lockmode=) at > > tablecmds.c:4152 > > I'm wondering if this repres

Re: [HACKERS] ALTER TABLE .. ALTER COLUMN .. ERROR: attribute .. has wrong type

2017-01-03 Thread Justin Pryzby
On Tue, Jan 03, 2017 at 02:50:21PM -0500, Tom Lane wrote: > Justin Pryzby <pry...@telsasoft.com> writes: > > On Tue, Jan 03, 2017 at 02:32:36PM -0500, Tom Lane wrote: > >> 2. Even better would be a stack trace for the call to errfinish, > >>

Re: [HACKERS] ALTER TABLE .. ALTER COLUMN .. ERROR: attribute .. has wrong type

2017-01-03 Thread Justin Pryzby
| integer | not null | plain| 200 | pmcelldowntimeauto | smallint | | plain| 10 | pmcelldowntimeman | smallint | | plain| 10 |

Re: [HACKERS] ALTER TABLE .. ALTER COLUMN .. ERROR: attribute .. has wrong type

2017-01-03 Thread Justin Pryzby
On Tue, Jan 03, 2017 at 02:32:36PM -0500, Tom Lane wrote: > Justin Pryzby <pry...@telsasoft.com> writes: > >>>> I can cause the error at will on the existing table, > > That's good news, at least. > > 1. Please trigger it with "\set VERBOSITY verbose&q

Re: [HACKERS] ALTER TABLE .. ALTER COLUMN .. ERROR: attribute .. has wrong type

2017-01-03 Thread Justin Pryzby
On Tue, Jan 03, 2017 at 01:40:50PM -0500, Robert Haas wrote: > On Tue, Jan 3, 2017 at 11:59 AM, Justin Pryzby <pry...@telsasoft.com> wrote: > > On Tue, Jan 03, 2017 at 11:45:33AM -0500, Robert Haas wrote: > >> > ts=# begin; drop view umts_eric_ch_switch_view, > >

Re: [HACKERS] ALTER TABLE .. ALTER COLUMN .. ERROR: attribute .. has wrong type

2017-01-03 Thread Justin Pryzby
nto this state from a fresh initdb from a current version. I considered that perhaps it only affected our oldest tables, and would stop happening once they were dropped, but note this ALTER is only of a parent and its 3 most recent children. So only the empty parent could be described as "old"

Re: [HACKERS] ALTER TABLE .. ALTER COLUMN .. ERROR: attribute .. has wrong type

2017-01-02 Thread Justin Pryzby
On Wed, Oct 12, 2016 at 10:25:05AM -0500, Justin Pryzby wrote: > > I don't have a clear recollection how I solved this in July; possibly by > > restoring the (historic, partition) table from backup. > > > > Last week again again just now (both under 9.6), a

Re: [HACKERS] ALTER TABLE .. ALTER COLUMN .. ERROR: attribute .. has wrong type

2017-01-02 Thread Justin Pryzby
this at least 4 times now, on PG95 and 9.6; 3 of those times are for the above table. Any ideas what I can do to either reproduce it or otherwise avoid it ? On Wed, Oct 12, 2016 at 10:25:05AM -0500, Justin Pryzby wrote: > We've seen this happen at least once on a 9.5 server, and twice on (the s

Re: [HACKERS] Odd behavior with domains

2016-06-23 Thread Justin Dearing
a D. Drake" <j...@commandprompt.com> writes: > > So this came across my twitter feed: > > https://pbs.twimg.com/media/ClqIJtmXEAA5IGt.png > > public.text can exist in parallel with pg_catalog.text. > > It just doesn't seem right to me to be able to do: CREATE DOMAIN int AS varchar(50); Justin

Re: [HACKERS] Lets (not) break all the things. Was: [pgsql-advocacy] 9.6 -> 10.0

2016-05-13 Thread Justin Clift
that nobody > has seriously tried using lawyers to control/ruin the project. > > And, most importantly, we've been lucky that a lot of competing projects > have self-immolated instead of being successful and brain-draining our > contributors (MySQL, ANTS, MonetDB, etc.) Oracle buying

Re: [HACKERS] Lets (not) break all the things. Was: [pgsql-advocacy] 9.6 -> 10.0

2016-04-12 Thread Justin Clift
On 12 Apr 2016, at 17:23, Merlin Moncure <mmonc...@gmail.com> wrote: > On Mon, Apr 11, 2016 at 11:39 AM, Justin Clift <jus...@postgresql.org> wrote: >> Moving over a conversation from the pgsql-advocacy mailing list. In it >> Simon (CC'd) raised the issue of potential

Re: [HACKERS] Lets (not) break all the things. Was: [pgsql-advocacy] 9.6 -> 10.0

2016-04-12 Thread Justin Clift
On 12 Apr 2016, at 14:12, Yury Zhuravlev <u.zhurav...@postgrespro.ru> wrote: > Justin Clift wrote: >> Simon included a short starter list of potentials which might be in >> that category: >> >> * SQL compliant identifiers >> * Remove RULEs >> * Ch

[HACKERS] Lets (not) break all the things. Was: [pgsql-advocacy] 9.6 -> 10.0

2016-04-11 Thread Justin Clift
lly we can get it all done without giving users a reason to consider switching. ;) Regards and best wishes, Justin Clift -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was l

Re: [HACKERS] pg9.4 relpages of child tables

2015-03-18 Thread Justin Pryzby
On Wed, Mar 18, 2015 at 12:11:22PM -0400, Tom Lane wrote: Justin Pryzby pry...@telsasoft.com writes: I believe there's been a behavior change, and not sure if it's deliberate. I don't think there's a negative consequence for our production use, but it confused me while summing relpages

[HACKERS] pg9.4 relpages of child tables

2015-03-18 Thread Justin Pryzby
, is there any documentation of it? I'd prefer to avoid analyzing all our child tables, as all queries hit the parents, which include statistics on the children. Thanks, Justin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

[HACKERS] ruby connect

2009-05-30 Thread Justin Carrera
I'm trying to connect ruby to postgres on ubuntu and the only link I found that has the library is down. Does anyone have the postgres library for ruby? Or direct me to it? Justin Darby Carrera Database Programmer/Analyst MED-Department of Medical Social Sciences j-carr

Re: [HACKERS] windows doesn't notice backend death

2009-05-03 Thread justin
Tom Lane wrote: Have M$ really been stupid enough to make an external kill look just like an exit() call? regards, tom lane kind of :-( Everything i have read seems to point the Task Manager calls TerminateProcess() in the kernel32.dll and passes a 1 setting the exitcode to 1. I

Re: [HACKERS] windows doesn't notice backend death

2009-05-03 Thread justin
Andrew Dunstan wrote: justin wrote: Would it not be easy to set the normal exitcode to something other than 1 to see the difference ExitProcess() Not really, as Tom showed later this is an example of a more general problem. I think his solution of detecting when backends have cleaned

Re: [HACKERS] [GENERAL] string_to_array with empty input

2009-04-07 Thread justin
Steve Crawford wrote: Did I miss the exciting conclusion or did this drift silently off radar? it was pretty well split between the options. tabled for another time. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] [GENERAL] string_to_array with empty input

2009-04-01 Thread justin
Tom Lane wrote: Robert Haas robertmh...@gmail.com writes: On Tue, Mar 31, 2009 at 10:44 AM, Greg Stark st...@enterprisedb.com wrote: On Tue, Mar 31, 2009 at 3:42 PM, Sam Mason s...@samason.me.uk wrote: string_to_array('',',')::INT[] = invalid

Re: [HACKERS] [GENERAL] string_to_array with empty input

2009-04-01 Thread justin
If someone can show me a real world example this logic simplifies the code and has more uses I'll bite I just presently can't see how this works better. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] [GENERAL] string_to_array with empty input

2009-04-01 Thread Justin
Martin Gainty wrote: Split strings into array elements using provided delimiter string_to_array('xx~^~yy~^~zz', '~^~') output: {xx,yy,zz} http://www.postgresql.org/docs/8.3/interactive/functions-array.html Sorry thats not the question i'm asking. We are debating if it makes

Re: [HACKERS] [GENERAL] string_to_array with empty input

2009-03-31 Thread justin
Sam Mason wrote: I'd expect 3,2,1 and 1. That's also a disingenuous example; what would you expect back from: select count_elements(string_to_array('butter,,milk',',')) I think the semantics you want is what you'd get from: array_filter_blanks(string_to_array($1,$2)) where I defined

Re: [HACKERS] [GENERAL] string_to_array with empty input

2009-03-31 Thread justin
Sam Mason wrote: string_to_array('',',')::INT[] = invalid input syntax for integer: Which you don't get at the moment; although you do currently get it in other common cases such as: string_to_array('1,',',')::INT[] If you want backwards compatible behaviour you could always bung a

Re: [HACKERS] [GENERAL] string_to_array with empty input

2009-03-31 Thread justin
Greg Stark wrote: On Tue, Mar 31, 2009 at 5:48 PM, justin jus...@emproshunts.com wrote: But consider this fails also select string_to_array('1, , 3', ',' )::int[] = ERROR: invalid input syntax for integer: " " yet this works select string_to_array('1, 2, 3'

Re: [HACKERS] [GENERAL] string_to_array with empty input

2009-03-31 Thread justin
This thread being cross posted has made it a bit confusing Greg Stark wrote: Nobody has ever suggested filtering out empty elements or dealing specially with spaces or anything else like that. If you're talking about that then you've missed the original question. "Does anyone want

[HACKERS] math error or rounding problem Money type

2008-06-07 Thread Justin
I believe i have found a math bug/rounding problem with Money type when its used with SUM()... Postgresql 8.3.1 --- Background on the Problem We have gl_trans table with 92,000 rows with one column containing the positive and negative entries. In order to

Re: [HACKERS] math error or rounding problem Money type

2008-06-07 Thread Justin
Tom Lane wrote: Justin [EMAIL PROTECTED] writes: I believe i have found a math bug/rounding problem with Money type when its used with SUM()... Postgresql 8.3.1 You do know that money only stores two fractional digits? regards, tom lane yes

Re: [HACKERS] [PERFORM] Memory question on win32 systems

2008-05-29 Thread Justin
Sabbiolina wrote: On Thu, May 29, 2008 at 2:11 AM, Douglas McNaught [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: On Wed, May 28, 2008 at 7:05 PM, Sabbiolina [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hello, in my particular case I need to configure Postgres to

Re: [HACKERS] [PERFORM] Memory question on win32 systems

2008-05-29 Thread Justin
Merlin Moncure wrote: On Thu, May 29, 2008 at 10:19 AM, Justin [EMAIL PROTECTED] wrote: To my understanding Postgresql only caches queries and results in memory for that specific connection. So when that connection is closed those cached results are cleared out.So cached indexs

[HACKERS] transaction support in pl/slql

2008-03-12 Thread Justin
i have a request ?? Is there any intension of expanding Transaction support into PL/SQL. this would simplify GUI/client code to know the if a function failed it roll back the transaction. right now i have to pass back some kind error message that i look for to see if the transaction

[HACKERS] creating new aggregate function

2008-02-29 Thread Justin
Need help and direction creating new aggregate functions. We need to add more average functions for both scientific and finical purposes RMS for electrical measurement purposes Mode for both electrical and finical Weighted Average finical purposes Generalized mean for electrical

[HACKERS] Ad Hoc Indexes

2008-02-18 Thread Justin
Question: We have recently moved PostgreSql as we just migrated to OpenMfg. i really like the database and PL/pgSQL its very similar to how FoxPro language layout so learning has been pretty easy. Now for my question It does not appear PostgreSQL does not have an Ad Hoc Indexes ability

Re: [HACKERS] Ad Hoc Indexes

2008-02-18 Thread Justin
creating Ad Hoc indexes on the fly in memory makes sense . I imagine it would be even faster if the index stayed in memory Tom Lane wrote: Justin [EMAIL PROTECTED] writes: Is there any plans in the future to add the ability for PostgreSQL to create Ad Hoc indexes if it makes sense

Re: [HACKERS] Ad Hoc Indexes

2008-02-18 Thread Justin
created from a website or other business analysis tool that someone might create Tom Lane wrote: Justin [EMAIL PROTECTED] writes: The idea of ad hoc indexes is speed up loop scans To prove my idea i created a sql file in PGAdmin that creates the indexes on the fly then runs the query

Re: [HACKERS] Ad Hoc Indexes

2008-02-18 Thread Justin
oops dam spell checker really should be rarely sorry Justin wrote: Then why are the estimates so far off??? If estimates where correct would it improve the performance that much. Vaccum is set to run automatically so the stats stay update. Total record count for the tables for all

Re: [HACKERS] Ad Hoc Indexes

2008-02-18 Thread Justin
the correct number by allot. Stephen Denne wrote: Justin wrote: Then why are the estimates so far off? Perhaps a really high correlation between those records where coitem_status = 'O' and those records in your date range. The planner estimates 1 row when restricting by both restrictions

Re: [HACKERS] Ad Hoc Indexes

2008-02-18 Thread Justin
there are certainly problems with this idea. Figuring out the cost to either create an index or just do table scan would be pain but not impossible. The hit to index a table in memory i don't think would be that bad compare to do 100's to thousands of loops with table scans. I see more

Re: [HACKERS] [pgsql-www] pg_autovacuum is nice ... but ...

2004-11-29 Thread Justin Clift
Bruce Momjian wrote: Should I add a TODO to warn if FSM values are too small? Is that doable? It sounds like it should be, and it would be a valuable pointer to people, so yep. Any idea who'd be interested in claiming it? Regards and best wishes, Justin Clift ---(end

Re: [HACKERS] Improvements to PostgreSQL

2004-07-26 Thread Justin Clift
to look at, and probably equivalent to something like Oracle's Data Guard. They use the different approach, but the end result is having a master and standby databases. Hope this is helpful. Regards and best wishes, Justin Clift Thanks, Suresh snip ---(end of broadcast

Re: [HACKERS] Improvements to PostgreSQL

2004-07-26 Thread Justin Clift
. i.e. Concord's eHealth, and probably Tivoli, OpenView, etc Hope that's useful. Regards and best wishes, Justin Clift Cheers, Patrick ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs

[HACKERS] pg_dump - option for just dumping sequences?

2004-07-15 Thread Justin Clift
of? :-) Regards and best wishes, Justin Clift ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] pg_dump - option for just dumping sequences?

2004-07-15 Thread Justin Clift
AUTHORIZATION? Arrrgh, yep. Thanks Chris, I must be in space cadet mode today. :( Regards and best wishes, Justin Clift Chris ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] [pgsql-www] Problems logging into CVS server

2004-07-13 Thread Justin Clift
have to be missing something in the config *sigh* Um, that sounds worrying. Was the activity of the hacker anything that would affect PG code, or access to anything sensitive (account passwords, etc)? Regards and best wishes, Justin Clift ---(end of broadcast

Re: Release planning (was: Re: [HACKERS] Status report)

2004-07-13 Thread Justin Clift
to make the right calls where needed. :) Regards and best wishes, Justin Clift ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] Status report

2004-07-11 Thread Justin Clift
and others out to end users. :) Regards and best wishes, Justin Clift ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[HACKERS] Loadable Oracle Personality: WAS LinuxTag wrapup thread

2004-07-06 Thread Justin Clift
8i rules, load a set of Oracle 9i rules, load a set of DB2 x, rules, etc. :) Regards and best wishes, Justin Clift ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL

Re: [HACKERS] LinuxTag wrapup

2004-07-05 Thread Justin Clift
a couple of months since I was writing SQL in Oracle. Previous contract. :) Regards and best wishes, Justin Clift Regards, Mario Weilguni ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [HACKERS] LinuxTag wrapup

2004-07-04 Thread Justin Clift
, Justin Clift There's certainly no point supporting any weird ddl command, so there's still porting work to be done when migrating. Regards, Andreas ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your

Re: [HACKERS] Adding column comment to information_schema.columns

2004-07-04 Thread Justin Clift
for people who don't know the internals of the PG catalogs to be able to query the information schema, as in the information schema things are generally explicitly named. Much easier for non-experts, which most people don't want to have to invest the time in becoming. Regards and best wishes, Justin

Re: [HACKERS] Adding column comment to information_schema.columns

2004-07-04 Thread Justin Clift
with this? Regards and best wishes, Justin Clift Chris ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Adding column comment to information_schema.columns

2004-07-04 Thread Justin Clift
it and so on. :) Regards and best wishes, Justin Clift Chris ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] Adding column comment to information_schema.columns

2004-07-01 Thread Justin Clift
Tom Lane wrote: Justin Clift [EMAIL PROTECTED] writes: Not sure how worthwhile others will find this small patch (to CVS HEAD), but we found it useful. It adds the column comments to the information_schema.columns view. This question has been touched on before, but I guess it's time to face

[HACKERS] Bug with view definitions?

2004-07-01 Thread Justin Clift
^ mydb=# *** I haven't come across this before, and am having the same problem with pgAdmin3 as well, as it supplies the exact same definition of the view. I think I'm doing everything right here, could this be a bug with PG? Regards and best wishes, Justin Clift

Re: [HACKERS] Bug with view definitions?

2004-07-01 Thread Justin Clift
wasn't sure if it was PG or me. :) Um, as I'm not up to the task of fixing it, is this something you or someone else would be interested in? Regards and best wishes, Justin Clift ---(end of broadcast)--- TIP 7: don't forget to increase your free

Re: [HACKERS] Adding column comment to information_schema.columns

2004-07-01 Thread Justin Clift
but you know what I mean. :-) Regards and best wishes, Justin Clift Chris ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] Bug with view definitions?

2004-07-01 Thread Justin Clift
the pg_dump version of the query, or maybe see if the one in backend/catalog/information_schema.sql can be run directly. :) Regards and best wishes, Justin Clift ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] Adding column comment to information_schema.columns

2004-07-01 Thread Justin Clift
very neat. ? Regards and best wishes, Justin Clift ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing

[HACKERS] Adding column comment to information_schema.columns

2004-06-30 Thread Justin Clift
Hi all, Not sure how worthwhile others will find this small patch (to CVS HEAD), but we found it useful. It adds the column comments to the information_schema.columns view. Hope it's useful. :-) Regards and best wishes, Justin Clift *** information_schema.sql.orig 2004-07-01 11:59:26.0

[HACKERS] [Fwd: Re: Interesting thought....]

2003-07-21 Thread Justin Clift
someone wants to pick up. :-) Regards and best wishes, Justin Clift Original Message Subject: Re: Interesting thought Date: Mon, 21 Jul 2003 14:13:49 -0400 (EDT) From: Bruce Momjian [EMAIL PROTECTED] To: Justin Clift [EMAIL PROTECTED] This would fix all our inheritance

Re: [HACKERS] Two weeks to feature freeze

2003-06-20 Thread Justin Clift
at PostgreSQL 7.4 release instead of 8.0. It kind of doesn't sound right, having a protocol change in the 7 series, when we have an 8 series coming up soon after. Oh well, so it's not perfect... ;-) Regards and best wishes, Justin Clift snip ---(end of broadcast

[HACKERS] [Fwd: [GENERAL] [CYGWIN] Problems compiling PostgreSQL 7.3.3-1 underWin98]

2003-06-19 Thread Justin Clift
Hi everyone, Can anyone assist Diogo here? He's not some random user, he's our official Portuguese translator and helps us out a lot. Sounds like he really needs a hand. *please* Regards and best wishes, Justin Clift Original Message Subject: [GENERAL] [CYGWIN] Problems

Re: [HACKERS] Translation

2003-06-19 Thread Justin Clift
a completely new community to PostgreSQL, if you wouldn't mind doing that. :-) Regards and best wishes, Justin Clift P.M wrote: Hi, Ok so if i can't help you in the code, maybe i can help you translating installation comments into several languages ? I know, french, slovak, spanish

Re: [HACKERS] Compiling Win32

2003-06-14 Thread Justin Clift
Hi Jan, Do you have an ETA for this? :-) Regards and best wishes, Justin Clift Bruce Momjian wrote: I have not tested the Win32 compile in a few weeks, so it is possible it is broken at this point. It will not run because we need exec() handling that Jan is working on, and signal stuff

Re: [HACKERS] Compiling Win32

2003-06-14 Thread Justin Clift
Bruce Momjian wrote: Justin Clift wrote: Hi Jan, Do you have an ETA for this? I was going to report the Win32 status this week. As you know, I had to leave Win32 to catch up on email. The two big items left are exec() handlling and signals. If I can get those in by July 1, I can continue

Re: [HACKERS] Compiling Win32

2003-06-14 Thread Justin Clift
Bruce Momjian wrote: Justin Clift wrote: Bruce Momjian wrote: Justin Clift wrote: Hi Jan, Do you have an ETA for this? I was going to report the Win32 status this week. As you know, I had to leave Win32 to catch up on email. The two big items left are exec() handlling and signals. If I

Re: [HACKERS] PostgreSQL under Windows

2003-06-13 Thread Justin Clift
environments should be ok. :-) Regards and best wishes, Justin Clift Robert Treat wrote: On Wed, 2003-06-11 at 08:03, Bruno Wolff III wrote: On Tue, Jun 10, 2003 at 22:34:04 -0700, P.M [EMAIL PROTECTED] wrote: I was thinking that PostgreSQL could help me to reduce the cost of a such software

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-09 Thread Justin Clift
. :-) Regards and best wishes, Justin Clift regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through

Re: [HACKERS] Wrong version of jdbc in 7.3.3 rpms

2003-06-06 Thread Justin Clift
/documents/ReleaseProcess Regards and best wishes, Justin Clift --Barry Original Message Subject: Re: [JDBC] Official JDBC driver release ? Date: Thu, 05 Jun 2003 08:14:40 +0200 From: Thomas Kellerer [EMAIL PROTECTED] To: [EMAIL PROTECTED] References: [EMAIL PROTECTED] [EMAIL

Re: [HACKERS] 7.3.2 make failed on AIX4.3 using native c compiler

2003-04-01 Thread Justin Clift
Hi John, Marco Pratesi [EMAIL PROTECTED] wrote a step-by-step guide for compiling PostgreSQL on AIX a while ago: http://techdocs.postgresql.org/guides/CompilingForAIX Hope that helps. :-) Regards and best wishes, Justin Clift John Liu wrote: I config and make the 7.3.2 on the one works

Re: [HACKERS] Numbering of the next release: 8.0 vs 7.4

2003-03-12 Thread Justin Clift
. Sounds great. I just don't want it to take _ages_ to accomplish. :) Regards and best wishes, Justin Clift -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition

  1   2   3   4   >