Re: [GENERAL] Maximum transaction rate

l hdparm -I lets you check if write caching is on, hdparm -W lets you toggle it off. That's for ATA disks; SCSI ones can use sdparm instead, but usually it's something you can adjust more permanently in the card configuration or BIOS instead for those. -- * Greg Smith gsm..

Re: [GENERAL] Maximum transaction rate

On Fri, 6 Mar 2009, Ben Chobot wrote: How does turning off write caching on the disk stop the problem with LVM? It doesn't. Linux LVM is awful and broken, I was just suggesting more details on what you still need to check even when it's not involved. -- * Greg Smith gsm...@gre

Re: [GENERAL] Maximum transaction rate

eader to modify the sysbench test to use O_SYNC/O_DIRECT in order to re-test LVM for the situation if you changed wal_sync_method=open_sync , how to do that is mentioned briefly at http://sysbench.sourceforge.net/docs/ -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- 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] Maximum transaction rate

he other ameliorating factor here is that in order for this to bite you, I think you'd need to have another, incorrectly ordered write somewhere else that could happen before the delayed write. Not sure where that might be possible in the PostgreSQL WAL implementation yet. --

Re: [GENERAL] Maximum transaction rate

be re-writing already allocated space, which makes this category of journal mayhem not so much of a problem. But when I read about fsync doing unexpected things, that gets me more concerned. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD - Sent via pgsql-general mail

Re: [GENERAL] postmaster never finishes starting up, silent to boot

ht permissions on the copy. Once you get the log output on the screen it should narrow the possibilities here. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD - 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] Maximum transaction rate

makes the only UNIX{-ish} OS where the default is a genuine sync write Solaris. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD - Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mail

Re: [GENERAL] Is there a meaningful benchmark?

But when you consider the speed with which Oracle produces patches vs. the Postgres folks the winner is clearly the latter. Greg Williamson -- 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] Is there a meaningful benchmark?

ollected links to a bunch at http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL:_Comparing_Reliability_and_Speed_in_2007#Sun_Microsystems_2007_jAppServer2004_Benchmark_Results -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-general ma

Re: [GENERAL] Is there a meaningful benchmark?

3/static/wal-reliability.html On MySQL, the parameters that controls this behavior are described starting at http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#sysvar_innodb_flush_log_at_trx_commit For something with lots of disk commits, it's critical that you have both systems

Re: [GENERAL] commit performance anomaly

r faster write performance though. SAN vendors seem completely incompetant at producing out of the box tunings that work well for database use (I feel a RAID5 rant brewing). -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-general mailing lis

Re: [GENERAL] string_to_array with empty input

that picking an arbitrary choice is going to be more useful in practice though. -- Greg On 30 Mar 2009, at 23:26, Tom Lane wrote: Steve Crawford writes: I have a query that converts a string to an array with the string_to_array function. Sometimes the input is an empty string (not a null, but a

Re: [GENERAL] string_to_array with empty input

r individually, but have to unnest the list for some display purposes. The cases where it makes more sense to return a singleton array are going to be parsing things like /etc/password where there are specific meanings for each element, but when some are optional. I can't think of any exampl

Re: [GENERAL] string_to_array with empty input

On Tue, Mar 31, 2009 at 3:42 PM, Sam Mason wrote: > >  string_to_array('',',')::INT[]  => invalid input syntax for integer: "" Oof. That's a good point. -- greg -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] string_to_array with empty input

list of objects. The example of string_to_array('',',')::int[] is relevant to this point. The whole "there's one empty element" only makes sense if you're thinking in terms of string processing. If it's a list of any other kind of object it probably do

Re: [GENERAL] string_to_array with empty input

n any use case where the string was a list of objects it's almost certainly intended to be an empty list. And databases are almost always processing lists of things. I think the only use case where you want it to be a singleton list of an empty string is when you're doing string parsing su

Re: [GENERAL] string_to_array with empty input

ted? What would it look like if it was a zero-length list? You can ask what would it look like if it was a shopping list of one item called ''. But I agree both are theoretically consistent, but one is actually useful in 99% of use cases. The other is only useful in unusual cases. -- greg -- 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] Server Performance

bonnie++ on the hardware. That should give you a better idea what's going on here, and if the badness shows up there it will be much easier to get someone at IBM to pay attention too. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-gener

[GENERAL] Indexing unknown words with Tsearch2

, when the word is not in the dictionnary, neither in the stop words ? - If yes, how ? I'm also interested in any information you could give me... Many thanks ! Greg Maitrallain. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

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

foo','bar']),(array['foo','bar','baz'])) as input(input); input |output ---+--- {}| {foo} | {foo} {foo,bar} | {foo,bar} {foo,bar,baz} | {foo,bar,baz} (4 rows) postgres=# select input,

Re: [GENERAL] user defined aggregate for percentile calculations

plementation, rather than dropping into Perl. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- 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] nooby Q: temp tables good for web apps?

the early development stages is to create a seperate disk partition for the temporary tables, turn that into a tablespace, and then use temp_tablespaces to point the temp tables toward it. The idea is to separate out I/O to the temp tables so that you can measure it to see how significant it is. -- *

Re: [GENERAL] nooby Q: temp tables good for web apps?

7;s a disk controller with a write cache involved, that narrows the gap between SDD and regular drives quite a bit. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscrip

Re: [GENERAL] Now I am back, next thing. Final PGS tuning.

.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- 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] Now I am back, next thing. Final PGS tuning.

above are not really clear in the tuning guide on the wiki, I'll do an update to improve those sections when I get a minute. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes t

Re: [GENERAL] Some suggestions for the non Linux installers

ited" in this situation would help a lot of people out. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- 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] Minimizing Recovery Time (wal replication)

tions here are: 1) Decrease the maximum possible segment backlog so you can never get this far behind 2) Increase the rate at which random I/O can be flushed to disk by either a) Improving things with a [better] battery-backed controller disk cache b) Stripe across more disks -

Re: [GENERAL] Minimizing Recovery Time (wal replication)

und performance to be... inconsistent at best. Yeah, EBS is not exactly a high-performance or predictable database storage solution, particularly when you get to where you're calling fsync a lot--which is exactly what is happening during the period you note your system is frozen. -- * Greg S

Re: [GENERAL] Disconnected editing - versioning of databases

e they're filled with solutions to hard problems most people never even think they need to solve, until they get bit by one. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] Space for pg_dump

on ratio estimate, from there you can make a fairly accurate guess of what the whole dump is going to take up, presuming your data is fairly evenly distributed such that the first records that come back are typical of the whole thing. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com

Re: [GENERAL] New 8.4 features

is a good place to find PostgreSQL oriented blogs at. I've been collecting 8.4 related blog and talk presentations onto a list at http://wiki.postgresql.org/wiki/Waiting_for_8.4 and encourage others to expand on that with ones I've missed. -- * Greg Smith gsm...@gre

Re: [GENERAL] Selling an 8.1 to 8.3 upgrade

matrix should also provide you some ideas for features you might find useful in the newer version. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- 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] Huge sample dataset for testing.

in various ways to play with. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- 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] could not bind IPv4 socket

_address='*' So that the server is remotely accessible from all of its interfaces, and then you can do all filtering of who can connect just via pg_hba.conf instead. See http://www.postgresql.org/docs/8.3/static/auth-pg-hba-conf.html for more information. -- * Greg Smith gsm...@gre

Re: [GENERAL] bizgres

//www.ketl.org/ http://jasperforge.org/plugins/project/project_home.php?group_id=102 -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- 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] Best way to monitor, control, or rewrite data definition commands?

appropriate log rotation is needed to give you breakpoints to import at though. The other common idiom here to detect changes is to save the output from "pgdump -s" regularly and look for changes via diff. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD

Re: [GENERAL] Space for pg_dump

does, as a different type of report. Accordingly, I just updated with examples of both types, as well as something to work against pre-8.1 databases. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or

Re: [GENERAL] Direct I/O and postgresql version

. You can certainly find situations where sync writes end up working out better, but they're not common. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your sub

Re: [GENERAL] [Windows] Feedback on PG?

ng on AV in the FAQ: http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows#What_Anti-Virus_software_is_compatible.3F with a note referring to that in the install section above it where this info used to live. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmit

Re: [GENERAL] How to speed up the first-time-searching in pgsql?

might be all that's actually needed. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- 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] Postgres Clustering

ould go on, just send it to -general rather than cc'ing multiple ones. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- 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] Favorite/Recommended ERD tools

On Wed, 27 May 2009, Kevin Kempter wrote: I'm looking for suggestions per good ERD tools (Linux based preferred). There's a giant list that includes lots of ERD tools at http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools -- * Greg Smith gsm...@gregsmit

Re: [GENERAL] Bloated Table

accurate enough for gross maintenance use when I did a quick check of its results before, but those were tables without variable widths, TOAST, etc. This is one of those boring tasks that DBAs really want more monitoring-friendly visibility into. -- * Greg Smith gsm...@gregsmith.com http

Re: [GENERAL] Group By and wildcards...

where ... group by a.id,b.id,c.id ) AS sub WHERE a.id = a_id AND b.id = b_id AND c.id = c_id But that's pretty silly and not usually necessary. -- greg ---(end of broadcast)--- TIP 3: if posting/reading through U

Re: [GENERAL] Emacs and postgres

t gives me a history and editing. -- greg ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] row numbering

obably best off doing this in the client. You can do any sort of level break logic you need in the client, and even refer to previous records. The only thing that would make doing it in the client awkward would be if you were planning to use the results in more query logic such as a join. -- g

Re: [GENERAL] Hash aggregates blowing out memory

Mike Harding <[EMAIL PROTECTED]> writes: > The following was run -immediately- after a vacuum. You realize "vacuum" doesn't update the statistics, right? You have to do "analyze" or "vacuum analyze" for that. -- greg

Re: [GENERAL] multicolumn GIST index question

an index on the first column. There was some discussion on changing this but there wasn't consensus on which direction to head with it. It may come up again for 8.1 if someone wants to look at it. -- greg ---(end of broadcast)--- TIP 3: if pos

Re: [GENERAL] Splitting tables or databases? That's the problem

Get a better computer to run it on in teh long-term -- that will be your best investment <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On a 128MB RAM, 450 MHz pentium 3 server with linux gentoo and postgresql > 7.4.6 on an office lan we can manage satisfactorily a db c

Re: [GENERAL] Performance of Views

-Method better then the first Method on > the existing tables!? A view doesn't change performance at all. It's exactly the same as writing the query in the view directly into your query. -- greg ---(end of broadcast)--- TIP 6:

Re: [GENERAL] Database Name

"Envbop" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi > > I've just inherited a PostgreSQL database, for which I do not have any > details of, like database name or the users. > This used to be a library database which was managed via a web page > written > in php. > Its runni

Re: [GENERAL] pgadmin3 / postgresql newbie question

That particular error message is typically associated with a missing pg_hba.conf entry that tells the postgreSQL server which remote machines to allow connections FROM # If you want to allow non-local connections, you need to add more # "host" records. Also, remember TCP/IP connections are

Re: [GENERAL] Compatible Dumps

In practice it works well enough though. -- greg ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] preserving data after updates

I use a modified form of option 3 with an ON UPDATE RULE the update rule copies the row to an inherited table... CREATE TABLE dm_user ( id SERIAL NOT NULL PRIMARY KEY, lu_user_type INTEGER NOT NULL REFERENCES lu_user_type(id), dm_user_address INTEGER NOT NULL DEFAULT 0,

Re: [GENERAL] preserving data after updates

-Original Message- From: Berend Tober [mailto:[EMAIL PROTECTED] Sent: Friday, March 04, 2005 8:47 AM To: Greg Patnude Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] preserving data after updates > I use a modified form of option 3 with an ON UPDATE RULE the update r

Re: [GENERAL] About Access paths

ized table". But even that's not on the horizon right now. -- greg ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] Stuck with a query...

y sort those again. You could maybe make it faster by having an index on and doing order by "session_id desc, sequence_num desc". And giving this session a larger than normal sort_mem would give it a better chance of being able to use hash_agg for the count. -- greg

Re: [GENERAL] partitionning

s on tremendously inefficient purging and loading procedures when it would be possible to do these things instantaneously. That only becomes more important as the investment they want to leverage becomes larger. -- greg ---(end of broadcast)--- TIP 3: i

Re: [GENERAL] partitionning

they have to pull off 10GB of data because their system is 10x faster at doing this unnecessary work than mine would be, so it only takes 100x as much time? -- greg ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] partitionning

I have a strong feeling what really _ought_ to happen here is that the inherited tables support in postgres, which never really worked anyways, should be deprecated and eventually removed. All that infrastructure should be repurposed into partitioned tables. That seems like it would

Re: [GENERAL] partitionning

racle and DB2 DBAs. The only choice is whether they're doing it by kludging a failure-prone and suboptimal system or whether it's built into the database in a reliable, convenient, and well designed form. -- greg ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] [PATCHES] A way to let Vacuum warn if FSM settings are low. [final?]

TICE: the number of page slots needed (704) exceeds max_fsm_pages > (2) > HINT: Consider increasing the configuration parameter > "max_fsm_relations" > to a value over 704. > VACUUM Those statements seem a tad strange with those numbers...

Re: [GENERAL] pseudo-serial values in dual primary key?

er you should realize that sequences can skip numbers. If you really need them to be sequential then you'll have to lock the table in your trigger and "select max(id)" for your category. This will be much much slower. -- greg ---(end of broadcast)

Re: [GENERAL] Query performance problem

the right solution for you. Perhaps something simpler like libdb or memcached would be more appropriate. -- greg ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [GENERAL] Copression

gt; No, unless SSL compresses automatically. Without checking the source, I'll bet it does. Any good encryption system should compress first. -- greg ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[GENERAL] Changing constraints to deferrable

tions as soon as I try to delete a referenced column even after "set constraints all deferred". -- greg ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Changing constraints to deferrable

Tom Lane <[EMAIL PROTECTED]> writes: > Greg Stark <[EMAIL PROTECTED]> writes: > > Is it enough to just do > > update pg_constraint set condeferrable = 't' where contype = 'f'; > > I think you'd need to start a fresh backend sessio

Re: [GENERAL] checkpoint_timeout

nt timeout set to 30m. That seems to be a bogus setting that's just hiding some of the i/o by postponing it until after the test ends. -- greg ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

Re: [GENERAL] Delay INSERT

UNIQUE constraint and another transaction has an insert or update pending for the same key. If the other transaction commits you get a unique constraint violation, if it aborts your insert succeeds. -- greg ---(end of broadcast)--- TIP 7: don't

Re: [GENERAL] Table audit system

I use a modified form of option 3 with an ON UPDATE RULE the update rule copies the row to an inherited table... CREATE TABLE dm_user ( id SERIAL NOT NULL PRIMARY KEY, lu_user_type INTEGER NOT NULL REFERENCES lu_user_type(id), dm_user_address INTEGER NOT NULL DEFAULT 0,

Re: [GENERAL] Changing constraints to deferrable

"Florian G. Pflug" <[EMAIL PROTECTED]> writes: > Greg Stark wrote: > > I want all my foreign key constraints to be deferrable. They were all > > created > > with the default (not deferrable). > > Is it enough to just do update pg_constraint set

Re: [GENERAL] Changing constraints to deferrable

Michael Fuhr <[EMAIL PROTECTED]> writes: > On Wed, Mar 23, 2005 at 12:13:33PM -0500, Greg Stark wrote: > > > > Consider this a plea for an ALTER TABLE ALTER CONSTRAINT command :) > > Shouldn't ALTER TABLE DROP CONSTRAINT followed by ALTER TABLE ADD > CONSTRA

Re: [GENERAL] plperl doesn't release memory

he correct free() is always called. Ie, as long as perl doesn't hand any data structures to postgres expecting postgres to free it or vice versa. -- greg ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] plperl doesn't release memory

eed to do this just to work properly. Two mallocs can work fine alongside each other. They each call mmap or sbrk to allocate new pages and they each manage the pages they've received. They won't have any idea why the allocator seems to be skipping pages, but they should be carefu

Re: [GENERAL] Debugging deadlocks

your patch any worse than the current behaviour? -- greg ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] Debugging deadlocks

Alvaro Herrera <[EMAIL PROTECTED]> writes: > On Wed, Mar 30, 2005 at 05:41:04PM -0500, Greg Stark wrote: > > > > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > > > Is that true even if I'm updating/deleting 1,000 tuples that all reference > > t

Re: [GENERAL] Debugging deadlocks

, this would be very similar to how Oracle handles such locks. In that case there's a fixed amount of space per page reserved in advance for storing locks. Actually I think it's a bit more complicated. But that's the idea. -- greg ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] Debugging deadlocks

Tom Lane <[EMAIL PROTECTED]> writes: > Greg Stark <[EMAIL PROTECTED]> writes: > > Tom Lane <[EMAIL PROTECTED]> writes: > >> I looked at Paul's first message and thought "nah, that won't work > >> because ... because ... hmm ... hmmm ..

Re: [GENERAL] change attnum in pg_catalog.pg_attribute

t work and will likely crash the backend. Out of curiosity, would it work if the table were completely empty at the time? -- greg ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] Out of memory error on select

this is just a one-time query just do set enable_hashagg = off then run your query. -- greg ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[GENERAL] plpgsql default arguments

. Easy to do in C, C++, Perl, and Python (and, I assume Java), but I can't find anything in the documentation or on Google. Is it possible in plpgsql? Thanks, --greg -- Greg Lindstrom 501 975.4859 (office) Senior Programmer501 219-4455 (fax) NovaSys H

Re: [GENERAL] [INTERFACES] calculated identity field in views, again...

ry much that it will do anything useful. It sounds like Access wants to be able to update records by looking them up by primary key. In that case assigning a new value in your view will make Postgres make up a brand new number that is utterly useless for finding the record again later. -- greg --

Re: [GENERAL] [INTERFACES] calculated identity field in views, again...

l('seq') in your view. The problem is that every time you query it it will provide different numbers. I can't see that being useful. -- greg ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [PERFORM] [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL

hed by the decrease in i/o needed to use the index. -- greg ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [PERFORM] [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL

. It would be pretty useful. In fact if it isn't how hash indexes are implemented then it might be useful to provide a user visible hash(ROW) function that allows creating such indexes as functional indexes. Though hiding it would make the SQL simpler. -- greg --

Re: [PERFORM] [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL

dexing a hash function. -- greg ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [PERFORM] [GENERAL] "Hash index" vs. "b-tree index" (PostgreSQL

ering. Consider for example a query involving two or more hash indexes and the new bitmap indexscan plan. You don't want to fetch the tuples if you can eliminate them using one of the other indexes. -- greg ---(end of broadcast)--- TIP 9: the

Re: [GENERAL] regarding IN clause

but beware of using a single query to tune such parameters. And beware tuning them on non-production conditions. When the data grows and less of it fits in RAM you may have to raise it again. -- greg ---(end of broadcast)--- TIP 3: if posting/

Re: [GENERAL] numeric precision when raising one numeric to another.

much larger than 25 (think of monthly compounded 25 year mortgages, or worse, daily compounded savings accounts). But in those cases the base will be very close to 1. There's really no use case for NUMERIC^NUMERIC except in the case of an integral power which is useful for number the

Re: [GENERAL] Exception Handling in C-Language Functions?

this stuff or do I need to dive into the source? -greg ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] Compiling Postgresql 8.0.3 on Solaris 10

I suspect something stranger going on. Perhaps /bin/sh on this machine is bash and this user has some environment variable set that enables this non-standard behaviour? -- greg ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[GENERAL] Status of interactive psql's error handling?

quires starting from scratch. -- greg ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] Deleting orphaned records to establish Ref Integrity

table where parent_id = child_table.parent_id ) Which won't use anything as efficient as a hash join or merge join but will be at least capable of using index lookups for something basically equivalent to a nested loop. -- greg --

Re: [GENERAL] Determining when a row was inserted

rg/pgsql-hackers/2002-06/msg00085.php The followups are fascinating too. The next three messages immediately begin discussing how to get back this feature at least as an option. -- greg ---(end of broadcast)--- TIP 5: Have you checked our exten

Re: [GENERAL] Hash Function: MD5 or other?

ople trying to do that then MD5 is probably overkill. -- greg ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] [GENERAL] INHERITS and planning

g deeply nested inheritance graphs would show up an entirely different set of problem areas. -- greg ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [GENERAL] Viewing non-system objects in psql

"Greg Sabino Mullane" <[EMAIL PROTECTED]> writes: > I maintain that it makes more sense for those few people who regularly look > at system functions to add a "S" than to have everyone else have to do > things such as "\df public." @@aol(me too).

Re: [GENERAL] Advice on structure /sequence / trigger

ble yet and future changes might break my code. But I think it'll be workable. -- greg ---(end of broadcast)--- TIP 8: explain analyze is your friend

[GENERAL] CONVOLUTED CROSS-TAB ? UNION ? INTERSECT ? 16.9 second performance.... Is there a better way ???

64.83 rows=1000 width=211) (actual time=16726.014..16726.286 rows=1618 loops=1) Sort Key: activity_group, display_order, week_code Regards, Greg Patnude - Manager, Dynamic Applications Group Data Mosaics, Inc. 2406 South Dishman-Mica Road / Suite # 6 Spokane Valley, WA 99206-6429 VO

Re: [GENERAL] [HACKERS] [PATCHES] Removing Kerberos 4

ware of is a) it uses plain DES which is just a 56 bit key and crackable by brute force and b) cross-domain authentication is broken. But if you just have a single domain it's a lot simpler to set up than the poster child for second system effect, Kerberos 5. -- greg

<    6   7   8   9   10   11   12   13   14   15   >