Re: [GENERAL] work_mem greater than 2GB issue

is that the planner is estimating it will need 2G to has all the values and in fact it would need 8G. So for values under 2G it uses a sort and not a hash at all, for values over 2G it's trying to use a hash and failing. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get

Re: [GENERAL] DISTINCT ON without ORDER BY

= magic_transition, stype = a); Not sure it'll be faster though. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] Nooby Q: Should this take five hours? And counting?

in then yeah, it's pretty poor. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [GENERAL] Breaking national language support in Solaris 8

is just as good as the existing code. Just use regular gettext on the two strings separately and pick the right one based on the English rule. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! -- Sent via pgsql-general

Re: [GENERAL] What are the benefits of using a clustered index?

? But that's a secondary issue to getting it on the TODO list, which is all I'm suggesting at present. Well I think we need to be clear enough at least on the what if not the how. But there's a bit a of a fuzzy line between them I admit. -- Gregory Stark EnterpriseDB http

Re: [GENERAL] PostgreSQL versus MySQL for GPS Data

about very large at about 4-10 TB. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! - Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [GENERAL] Query 4-5 times slower after ANALYZE

something like creation_date = now() - expression Both because of the now() instead of 'now'::date and because the latter is a comparison that can be indexed instead of an expression which could use an index on creation_date. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask

Re: [GENERAL] Query 4-5 times slower after ANALYZE

than it saves in the query -- the reason these limits exist at all.. geqo_threshold join_collapse_limit from_collapse_limit -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning - Sent via pgsql-general mailing list

Re: [GENERAL] upgrade from 7.4 to 8.3

months and will allow you to have a different encoding and locale for each database. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] intermittant performance problem

on timestmp or item_name or some_data_field is sometimes being used and sometimes not. Perhaps it's switching from an index on one of those columns to an index on some other column and that's what's throwing it off. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get

Re: [GENERAL] postgresql and LDAP

that might help is that there should be more information about the problem in the postmaster log. We intentionally don't send details about the conf file's contents to the client... Perhaps we should send a HINT to the client saying to consult the postmaster logs? -- Gregory Stark

Re: [GENERAL] 8.3.6 build error on Debian Lenny

- hopefully don't get snarks. :) Yes well... -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] postgresql and LDAP

Emanuel Calvo Franco postgres@gmail.com writes: 2009/3/10 Gregory Stark st...@enterprisedb.com: Tom Lane t...@sss.pgh.pa.us writes: However, a tip that might help is that there should be more information about the problem in the postmaster log.  We intentionally don't send details about

Re: [GENERAL] Newbie questions relating to transactions

/start transactions freely. It also allows you to open multiple connections or run the client-side code on a separate machine which can have different resources available. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support

Re: [GENERAL] Problem with Mauritius summer time (MUST)

Summer Time explicitly. I think the problem is that MUST is missing from the Default timezone_abbreviations file. SELECT '2009-01-01 00:56:00 Indian/Mauritius'::timestamp with time zone; timestamptz 2008-12-31 19:56:00+00 -- Gregory Stark EnterpriseDB

Re: [GENERAL] Strange behavior: row won't delete

which block other transactions that's bad. Alternately if you see a query in pg_stat_transaction which is taking a long time to run you might check whether you have a bad plan or a bad query running while holding locks effectively doing the same thing. -- Gregory Stark EnterpriseDB http

Re: [GENERAL] funny view/temp table problem with query

. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Using xmin to identify last modified rows

column on your tables and manage the date you put in their according to a policy you control. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Using xmin to identify last modified rows

Richard Broersma richard.broer...@gmail.com writes: On Wed, Feb 25, 2009 at 5:21 AM, Gregory Stark st...@enterprisedb.com wrote: I'm not sure using xmin is such a great idea really. It's handy for ad-hoc queries but there are all kinds of cases where it might not give you the results you

Re: [GENERAL] Indexing a Bit String column

. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] \l of psql 8.4 looks ... unreadable on 80char default

I don't think the current logic is right I don't think wrapping to 80 columns when your terminal is wider is one of the current broken cases. It tends to fail in the opposite direction of randomly not wrapping at all so it's kind of surprising to see your experience. -- Gregory Stark

Re: [GENERAL] Bringing other columns along with a GROUP BY clause

(partition by charge order by coldspot_time desc) as r) where r = 1 ? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Vacuums taking forever :(

normal suggestion is to increase *vacuum_cost_delay* which tells it to sleep longer between bits of work. Don't increase it too much or vacuum will take forever. But if you increase it from 20 to 40 it should use half as much i/o as bandwidth as now. -- Gregory Stark EnterpriseDB http

Re: [GENERAL] C function question

and do something about this old gotcha. That type's not going away anytime soon, but could we rename it to char1 or something like that? int1? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! -- Sent via pgsql

Re: [GENERAL] Vacuums taking forever :(

sleeping which probably cause a lot of random seeks. If you multiple both by 10 then you'll process close to a megabyte of data and then sleep for a long while. Just a thought -- I haven't tried this on a test box.) -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get

Re: [GENERAL] Pet Peeves?

source base which is flexible enough to extend to use a database backend. I'm under the impression most cron daemons are based on pretty old and ossified source bases and are burdened by a lot of legacy compatibility requirements. -- Gregory Stark EnterpriseDB http

Re: [GENERAL] Full text index not being used, even though it is in the plan

with much more selective searches? If your full_listing values are quite large then recalculating the tsvector might be a lot more expensive than doing a full table scan and LIKE match for cases when nearly the whole table is going to be scanned anyways. -- Gregory Stark EnterpriseDB

Re: [GENERAL] Indices types, what to use. Btree, Hash, Gin or Gist

that in this example if you were to search on just age it wouldn't be able to use either of these indexes however. In theory it could use the indexes if you search on just gender but it would be unlikely to for all the same reasons as previously mentioned for regular indexes. -- Gregory Stark

Re: [GENERAL] Pet Peeves?

if a perl module exists in debian I just do perl -MCPAN -e 'install (DBD::Pg)' or whatever pkg Ah, well that's not a mistake, but you need to check what -dev packages the CPAN module you're building requires. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about

Re: [GENERAL] Indices types, what to use. Btree, Hash, Gin or Gist

the Hash is not recommended. When should I use the Gin index ? GIN and GIST are used for fairly specialized purposes. Full text searching, geometric data types, etc. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent

Re: [GENERAL] Pet Peeves?

the information about the columns, maybe by simply not allowing the dynamic-column ones in subqueries. What about a WHERE clause like WHERE P1 P2 -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via pgsql-general

Re: [GENERAL] Pet Peeves?

). Is it the hierarchical query ability you're looking for or pivot? The former we are actually getting in 8.4. AFAIK even in systems with pivot you still have to declare a fixed list of columns in advance anyways. Do you see a system where it works differently? -- Gregory Stark EnterpriseDB http

Re: [GENERAL] complex custom aggregate function

executed for every record and retrieved the set of data to aggregate. 8.4 Will have OLAP Window functions which can implement things like moving averages. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL

Re: [GENERAL] Pet Peeves?

Daniel Verite dan...@manitou-mail.org writes: Gregory Stark wrote: Is it the hierarchical query ability you're looking for or pivot? The former we are actually getting in 8.4. AFAIK even in systems with pivot you still have to declare a fixed list of columns in advance anyways. Do

Re: [GENERAL] Pet Peeves?

be a package bug. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] Pet Peeves?

improvements and HOT previously and the free space map in 8.4 the situation will be much improved. However there are still some common usage patterns where people run into problems. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production

Re: [GENERAL] Slow first query despite LIMIT and OFFSET clause

... -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

[GENERAL] Pet Peeves?

or if you prefer in personal emails. I do intend to use the ideas you give in my presentation so mark anything you wouldn't be happy to see in a slide at a conference some day. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support

Re: [GENERAL] Text search segmentation fault

really boggles me is why you don't just use unsigned chars everywhere and remove all of these casts. or would that just move the casts to strcmp and company? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! -- Sent via

Re: [GENERAL] Text search segmentation fault

Gregory Stark st...@enterprisedb.com writes: Teodor Sigaev teo...@sigaev.ru writes: I reproduced the bug with a help of Grzegorz's point for 64-bit box. So, patch is attached and I'm going to commit it ... !Conf-flagval[(unsigned int) *s] = (unsigned char) val; ... !Conf

Re: [GENERAL] Text search segmentation fault

Tom Lane t...@sss.pgh.pa.us writes: Gregory Stark st...@enterprisedb.com writes: Maybe I'm missing something but I don't understand how this fixes the problem. s is a char* so type punning it to an unsigned char * before dereferencing it is really the same as casting it to unsigned char

Re: [GENERAL] Pet Peeves?

, though I suppose there's always someone somewhere holding elections :) -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] Pet Peeves?

of wondering what behaviour you two are looking for and what different DBMS you're referring to. I'm assuming it's not the ANSI fold-to-uppercase behaviour you're looking for. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support

Re: [GENERAL] Pet Peeves?

to discussing the problems themselves and not debating the pros and cons of possible solutions. I want to encourage people to post their peeves even if they know perfectly well the reasons why things are the way they are. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about

Re: [GENERAL] Pet Peeves?

has to really make it a big success though. Making modules more, uh, modular, so they can be installed and uninstalled smoothly and preferably without special access privileges is a recognized issue though. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about

Re: [GENERAL] How relate pg_class to pg_constraint

a convenience type called regclass which you can use by doing SELECT conrelid::regclass from pg_constraint. There are similar regtype and a few others like it too. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via

Re: [GENERAL] PG's suitability for high volume environment (many INSERTs and lots of aggregation reporting)

suspect others already suggested this, but you might look at partial indexes. If your queries are very dynamic against relatively static data you might look at building denormalized caches of the precalculated data. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me

Re: [GENERAL] PgUS 2008 end of year summary

a Reply-To: pgsql-advocacy header or some such.) Yeah, actually that doesn't work. If you want to do that the only way to do it properly is to Bcc the various lists with the To set to the list you want followups to go to. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com

Re: [GENERAL] PgUS 2008 end of year summary

Alvaro Herrera alvhe...@commandprompt.com writes: Gregory Stark wrote: Alvaro Herrera alvhe...@commandprompt.com writes: Well cross-posting is especially annoying on subscriber-only moderated lists such as ours. Anyone who follows up to an email who isn't subscribed to all the lists

Re: [GENERAL] What determines the cost of an index scan?

it is how much dead space is in the table due to previous updates and deletes, as well as how fragmented the indexes have become over time. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-general mailing

Re: [GENERAL] Error: Operator does not exist: char=integer

why the casts disappeared -- you probably weren't running the queries you thought you were running in 8.2 and previously. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql

Re: [GENERAL] Maximum reasonable free space map

poorly because of the time spent sifting through all that dead space. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] tup_returned/ tup_fetched

://www.postgresql.org/docs/8.3/interactive/monitoring-stats.html -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Postgres mail list traffic over time

Craig Ringer [EMAIL PROTECTED] writes: Gregory Stark wrote: Another idea, I wonder if the project has gone more international and therefore has more traffic at odd hours of the day for everyone. It would also mean more long-lived threads with large latencies between messages and replies

Re: [GENERAL] Postgres mail list traffic over time

-analyze.info/ What would be really neat would be having the mailing list do something automatically. Either fix the message inline or generate a link to something like this. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent

Re: [GENERAL] Postgres mail list traffic over time

moving on to the next one. Another idea, I wonder if the project has gone more international and therefore has more traffic at odd hours of the day for everyone. It would also mean more long-lived threads with large latencies between messages and replies. -- Gregory Stark EnterpriseDB

Re: [GENERAL] Storage location of temporary files

. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Are there plans to add data compression feature to postgresql?

there though. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Are there plans to add data compression feature to postgresql?

could see this working is if you use a filesystem which logs data changes like ZFS or ext3 with data=journal. Even then you have to be very careful to make the filesystem block size that the journal treats as atomic match the Postgres block size or you'll still be in trouble. -- Gregory Stark

Re: [GENERAL] Are there plans to add data compression feature to postgresql?

Ivan Sergio Borgonovo [EMAIL PROTECTED] writes: On Fri, 31 Oct 2008 08:49:56 + Gregory Stark [EMAIL PROTECTED] wrote: Invisible under normal operation sure, but when something fails the consequences will surely be different and I can't see how you could make a compressed filesystem safe

Re: [GENERAL] Decreasing WAL size effects

and have it only bother copying up to that point? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Are there plans to add data compression feature to postgresql?

on a filesystem that felt free to compress portions of it. Would the filesystem still be able to guarantee that torn pages won't tear across adjacent blocks? What about torn pages that included hint bits being set? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about

Re: [GENERAL] psql screen size

SIGWINCH as well. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Are there plans to add data compression feature to postgresql?

Scott Marlowe [EMAIL PROTECTED] writes: On Thu, Oct 30, 2008 at 4:41 PM, Tom Lane [EMAIL PROTECTED] wrote: Scott Marlowe [EMAIL PROTECTED] writes: On Thu, Oct 30, 2008 at 4:01 PM, Gregory Stark [EMAIL PROTECTED] wrote: I can't really see trusting Postgres on a filesystem that felt free

Re: [GENERAL] psql screen size

to work around, just resize the window again a little bit once you're at the prompt. Readline notices that and adjusts. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] psql screen size

Gregory Stark [EMAIL PROTECTED] writes: Could you define messed up? What I see is that the query output is formatted correctly but readline still thinks the screen is the old size. (This is in CVS HEAD -- this code was definitely different in 8.3 and before so the behaviour may

Re: [GENERAL] PostgreSQL 8.3.3 chooses wrong query plan when LIMIT 1 added?

. One thing that comes to mind though, I would have defined one of those two indexes to include both columns. Probably the file_id index, so you would have an index on revision_id and an index on file_id,revision_id. That would be a huge win for this query. -- Gregory Stark EnterpriseDB

Re: [GENERAL] Drupal and PostgreSQL - performance issues?

such comments or de-emphasize them to help the user concentrate on the new material. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Drupal and PostgreSQL - performance issues?

. Then we can mmap as much as we want. Before we lose root privileges we can even mlock as much as we want. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] PQexecParams question

Grzegorz Jaśkiewicz [EMAIL PROTECTED] writes: that would be a type mismatch, heh. prepare select * from foo where a = any($1::int[]) then pass {1,2,3} -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's

Re: [GENERAL] Chart of Accounts

get charged $8.00 not $7.996. If you fail to round at that point you'll find that your totals don't agree with the amount of money in your actual bank account. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via

Re: [GENERAL] Out of memory in create index

has me confused. Can anyone shed some light on the situation? How much memory the OS allows Postgres to allocate will depend on a lot of external factors. At a guess you had some other services or queries running at the same time the first time which reduced the available memory. -- Gregory

Re: [GENERAL] Static functions

, which would be by far the most likely result if we tried to cache all function results. Sorry Tom, I confused STABLE with IMMUTABLE; my bad. No, this is equally untrue for immutable. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand

Re: [GENERAL] Index order

by their binary value which comes after all the unaccented characters. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Healing a table after massive updates

the cluster or alter table such as a long-running pg_dump. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] Healing a table after massive updates

Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Incidentally the visibility bugs are indeed entirely fixed in 8.3. In 8.2 and before cluster and alter table rewrites can both cause tuples to not appear for transactions which were started before the cluster or alter

Re: [GENERAL] recover in single-user backend fails

of gist_redo() in gistxlog.c and when recovery (hopefully) completes immediately drop any gist indexes? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] A challenge for the SQL gurus out there...

a recent_post_id) then you could have a query on forums which pulls the most recently updated thread directly without having to join on form_post at all. That would slow down inserts but speed up views -- possibly a good trade-off for a forum system. -- Gregory Stark EnterpriseDB http

Re: [GENERAL] MERGE: performance advices

pk. Then you'll have to build indexes, swap the tables, and fix any views or rules which refer to the old table (they'll still refer to the old table, not the new table even after renaming it to the old name). -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained

Re: [GENERAL] indexes on functions and create or replace function

the unavoidable window when the index is invalid. I'm not sure how to solve that. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] Postgres 8.3 is not using indexes

Clemens Schwaighofer [EMAIL PROTECTED] writes: Any tips why this is so? They don't appear to contain the same data. If they do have you run analyze recently? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support! -- Sent via

Re: [GENERAL] foreign key restrictions

anyways. I'm not sure if there's a fundamental reason why there has to be an index that exactly matches the foreign key or not -- offhand I can't think of one. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's

Re: [GENERAL] Initdb problem on debian mips cobalt: Bus error

Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Tom Lane [EMAIL PROTECTED] writes: (Rather than trying to browbeat configure into doing this, I'd suggest manually adjusting CFLAGS in src/Makefile.global, then make clean and rebuild.) eh? either of these should

Re: [GENERAL] Initdb problem on debian mips cobalt: Bus error

--enable-debug And yes, you have to do make clean. I often forget that step :( -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] AT TIME ZONE and DST in UTC-CET conversion

and CST automatically you should use something like Europe/Paris. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Memory use in 8.3 plpgsql with heavy use of xpath()

allocation anyways though. Few allocators return memory to the OS anyways. It might just be exaggerated in this case since probably a significant part of Postgres's footprint here was the per-transaction memory being used by this leak. -- Gregory Stark EnterpriseDB http

Re: [GENERAL] Functional index adding one

. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Functional index adding one

Gregory Stark [EMAIL PROTECTED] writes: CREATE INDEX token_position_func on (token(position+1)) Ooops, I misread that as if token were a function and not the table. Sam Mason had the right syntax. Sorry. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about

Re: [GENERAL] Switching between terminals

pg_sleep(10) between the two queries in the first file you run so that it hasn't updated both tables and exited before the second one even starts. But I'm just guessing since you haven't sent the actual files you're running. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com

Re: [GENERAL] Heavily fragmented table and index data in 8.0.3

you could use if you can stand the downtime is to periodically CLUSTER the table. Older versions of Postgres had a concurrency bugs in CLUSTER to watch out for, but as long as you don't run it at the same time as a very long-running transaction such as pg_dump it shouldn't be a problem. -- Gregory

Re: [GENERAL] when to reindex?

would be where you have a lot of dead space in the table (but not in the index), partial indexes which don't cover much of the table, or a table which is already very well clustered (possibly, depending on other factors). -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask

Re: [GENERAL] turning fsync off for WAL

backup images (make sure to read how to use pg_start_backup() properly) against longer recovery times. TANSTAAFL :( If you do this then you may as well turn fsync off on the server since you're resigned to having to restore from backup on a server crash anyways... -- Gregory Stark

Re: [GENERAL] turning fsync off for WAL

buffers whose changes haven't been logged yet too). -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Bottom Posting

message. My response was only to this one point and not the longer previous point. I actually think this is a more important point to get across than simply don't top post which just seems to generate lots of bottom posts that are just as bad. -- Gregory Stark EnterpriseDB http

Re: [GENERAL] Open Source CRM - Options?

specific name for this kind of system. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] active queries

connection using named portals. But if you called PQgetResult() on one you have to ensure all threads wait until it returns before issuing PQgetResult() (or any other libpq function) on the other portal. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce

Re: [GENERAL] Psql crashes with Segmentation fault on copy from

the later command -- before it was overwritten it was apparently \i bench-index-after.sql. It seems something with the PsqlScanState is not being sufficient to make the lexer completely reentrant here. What version of flex is this built with? -- Gregory Stark EnterpriseDB http

Re: [GENERAL] Bottom Posting

Bob Pawley [EMAIL PROTECTED] writes: The concept of most lists should be the free exchange of ideas in the most efficient manner possible. What is this in response to? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services

Re: [GENERAL] small table, huge table, and a join = slow and tough query. cake inside!

pollutant. To get anything more you would have to post an EXPLAIN output and preferably an EXPLAIN ANALYZE output if you can find a query which completes. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via

Re: [GENERAL] Error: Could not open relation...

about integrity issues if you started having the same error with something like an xlog WAL file though. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

  1   2   3   4   >