|
Mailing List Archive For pgsql-general@postgresql.org Sep 2007 By Subject- [GENERAL] "like" vs "substring" again
- [GENERAL] "not in" clause too slow?
- [GENERAL] %tsearch2-affix parse error dictionary spanish
- [GENERAL] 3 tables join update
- [GENERAL] 5 minutes to pg_dump nothing
- [GENERAL] 8.2.4 error restoring dump because of gin__int_ops
- [GENERAL] 8.3devel, csvlog, missing info?
- [GENERAL] =?ISO-8859-2?Q?libpg.dll problem while changing from version 8.2.4 no-installer to 8.2.5 n=
- [GENERAL] [Urgent] Regexp_replace question
- [GENERAL] A few basic troubleshooting questions
- [GENERAL] a problem with pg_hba.conf
- [GENERAL] a provocative question?
- [GENERAL] about pgpool question
- [GENERAL] about the PostgreSql loading?
- [GENERAL] access privileges: grant select on (all current and future tables)?
- [GENERAL] Actually Solved! Was: (Return t/f on existence of a join)
- [GENERAL] Adapter update.
- [GENERAL] Adding domain type with CHECK constraints slow on large table
- [GENERAL] Alias "all fields"?
- [GENERAL] Alias "all fields"?)
- [GENERAL] Alter sequence restart with selected value...
- [GENERAL] Alternative to drop index, load data, recreate index?
- [GENERAL] an other provokative question??
- [GENERAL] ANY
- [GENERAL] any with the output of coalesce
- [GENERAL] Arabic Language
- [GENERAL] archive_command with an environnement variable ?
- [GENERAL] array_to_records function
- [GENERAL] arrays of foreign keys
- [GENERAL] audit sql queries
- [GENERAL] Auto vacuum documentation
- [GENERAL] Autostart PostgreSQL in Ubuntu
- [GENERAL] autovacuum
- [GENERAL] AutoVacuum Behaviour Question
- [GENERAL] AUXILIO!!!! CONSULTA SOBRE CURSORES HELP!!! ABOUT CURSORS
- [GENERAL] avg() of array values
- [GENERAL] Best practice for specifying an interval
- [GENERAL] Bigtime scaling of Postgresql (cluster and stuff I suppose)
- [GENERAL] Building Windows fat clients
- [GENERAL] Calculate Weighted Aggregation between Two Tables
- [GENERAL] Call for Speakers PostgreSQL Conference Fall 2007
- [GENERAL] Can't connect (2 dbs) or login (2 others)
- [GENERAL] Cannot declare record members NOT NULL
- [GENERAL] Cannot install under Windows Vista
- [GENERAL] cascade and restrict options to alter domain drop constraint
- [GENERAL] Case insensitivity problem
- [GENERAL] cast time interval to seconds
- [GENERAL] Checking is TSearch2 query is valid
- [GENERAL] CLOB support in postgresql
- [GENERAL] CLUSTER = slower vacuum?
- [GENERAL] Column as arrays.. more efficient than columns?
- [GENERAL] Column Ordering
- [GENERAL] Compare Content in Multidimensional Array [PHP/SQL]
- [GENERAL] Compiling Pl/Perl on Mac OSX
- [GENERAL] computing and updating the size of a table with large objects
- [GENERAL] configuration question
- [GENERAL] Configuration starting point...
- [GENERAL] Connecting to PostgreSQL server with Mono using ident authetication
- [GENERAL] Connection pooling
- [GENERAL] Connection Pooling directly on Postgres Server
- [GENERAL] constrains on two tables
- [GENERAL] Controlling locale and impact on LIKE statements
- [GENERAL] could not [extend relation|write block N of temporary file|write to hash-join temporary file]
- [GENERAL] count (*)
- [GENERAL] CPU spike when doing PARSE (what is this?)
- [GENERAL] creating/dropping tables inside functions?
- [GENERAL] creation of tables with warnings
- [GENERAL] DAGs and recursive queries
- [GENERAL] Data cube in PostgreSQL
- [GENERAL] Data Model - Linking to PHP Code - Literature
- [GENERAL] Data Warehousing
- [GENERAL] Database owner can't analyze/vacuum all of the database tables
- [GENERAL] Database reverse engineering
- [GENERAL] Database/Table Design for Global Country Statistics
- [GENERAL] datestyle question
- [GENERAL] dblink vs dbi-link (and errors compiling)
- [GENERAL] Debian problem...
- [GENERAL] debuging transactions
- [GENERAL] decode access privileges
- [GENERAL] DELETE FROM pg_class
- [GENERAL] delta copies of pg_dump files
- [GENERAL] df output change (in psql) after 8.2 version
- [GENERAL] Do AGGREGATES consistently use sort order?
- [GENERAL] Documentation fix regarding atan2
- [GENERAL] Dumping from older version
- [GENERAL] Duplicate public schema and user tables
- [GENERAL] Error Message: invalid command-line arguments for server process
- [GENERAL] ERROR: must be superuser to alter superusers
- [GENERAL] ERROR: table row type and query-specified row type do not match
- [GENERAL] Event-driven programming?
- [GENERAL] Export data to MS Excel
- [GENERAL] Extra messages on my console.
- [GENERAL] FATAL: could not reattach to shared memory (Win32)
- [GENERAL] Filesystem crash - corupted database
- [GENERAL] fillfactor Question
- [GENERAL] Find "smallest common year"
- [GENERAL] For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER
- [GENERAL] For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER)
- [GENERAL] foreign key on views
- [GENERAL] foreign key violation error with partitioned table
- [GENERAL] Function to determine next payment date
- [GENERAL] get a list of table modifications in a day?
- [GENERAL] getting min/max of two values
- [GENERAL] Getting result from EXECUTE
- [GENERAL] Getting sequence name for a non-serial column
- [GENERAL] Getting the search_path value for a query listed in pg_stat_activity output (feature request?)
- [GENERAL] GRANT on group does not give access to group members
- [GENERAL] GRANT on information_schema & keys
- [GENERAL] Hardware recommendation: which is best
- [GENERAL] Help tuning a large table off disk and into RAM
- [GENERAL] help w/ SRF function
- [GENERAL] How to 'register' functions, so they can be called (plpythonu)
- [GENERAL] How to avoid: 9.50184e+06
- [GENERAL] How to clear bits?
- [GENERAL] how to find the number of rows inserted into the master table?
- [GENERAL] how to get the total statistics info and query time for many queries
- [GENERAL] how to ignore invalid byte sequence for encoding without using sql_ascii?
- [GENERAL] how to know the current size of a database
- [GENERAL] How to recover database instance from a disaster
- [GENERAL] How unsubscrib this list ?
- [GENERAL] importing large files
- [GENERAL] importing pgsql schema into visio (for diagramming)
- [GENERAL] Inheritance fixing timeline? (Was "Inherited FK Indexing")
- [GENERAL] Inherited FK Indexing
- [GENERAL] Inline Function documentation
- [GENERAL] Inserting a timestamp in a "timestamp" column.
- [GENERAL] Instances where enable_seqscan = false is good
- [GENERAL] invalid byte sequence for encoding "UTF8": 0xff
- [GENERAL] Is the ole db provider broken?
- [GENERAL] Is this good spec for a PostgreSQL server?
- [GENERAL] Issue with uninstalling postgres 8.1.9
- [GENERAL] It's time to support GRANT SELECT,UPDATE,...,...,... ON database.* to username
- [GENERAL] JOIN issues (Left vs Right for sorting), and "Nested Loop" problem
- [GENERAL] JOIN with ORDER on both tables does a sort when it souldn't
- [GENERAL] keeping 3 tables in sync w/ each other
- [GENERAL] Left joining table to setof function
- [GENERAL] Locking entire database
- [GENERAL] log_statement and PREPARE
- [GENERAL] lowering impact of checkpoints
- [GENERAL] Manually clearing "database "foo" is being accessed by other users"
- [GENERAL] Max File size per Table (1G limit??)
- [GENERAL] Memory usage of COPY command
- [GENERAL] Migrating from 32 bit to 64 bit binaries
- [GENERAL] Migration from PervasiveSQL
- [GENERAL] More on migragting the server.
- [GENERAL] more problems with count(*) on large table
- [GENERAL] Need suggestion on how best to update 3 million rows
- [GENERAL] New PostgreSQL RPM sets are available for Fedora / RHEL
- [GENERAL] New/Custom DataType - Altering definition / seeing definition in pgAdmin3
- [GENERAL] Normalized Tables & SELECT [was: Find "smallest common year"]
- [GENERAL] NOT NULL Issue
- [GENERAL] now() vs current_user
- [GENERAL] NZDT Question
- [GENERAL] Obtaining random rows from a result set
- [GENERAL] OK, when 8.3 is coming?
- [GENERAL] ON INSERT => execute AWK/SH/EXE?
- [GENERAL] ON UPDATE trigger question
- [GENERAL] Open Source Application Server (PostgreSQL Perspective)
- [GENERAL] Optimizing "exists"
- [GENERAL] oracle rank() over partition by queries
- [GENERAL] Out of Memory - 8.2.4
- [GENERAL] pam authentication
- [GENERAL] Partial index with regexp not working
- [GENERAL] Partition Reindexing
- [GENERAL] Performance issue with nested loop
- [GENERAL] Performance Issues
- [GENERAL] Performance Issues (was: "like" vs "substring" again)
- [GENERAL] PG levels vs. syslog levels
- [GENERAL] pg_dump (8.1.9) does not output copy statements
- [GENERAL] pg_dump doesn't dump everything?
- [GENERAL] pg_dump doesn¹t dump everything?
- [GENERAL] PG_DUMP not working
- [GENERAL] pg_dump problem: 'pg_dump: schema with OID 1515546 does not exist'
- [GENERAL] pg_dumping large objects
- [GENERAL] pg_restore - invalid file problem
- [GENERAL] pg_standby observation
- [GENERAL] pgcrypto: is an IV needed with pgp_sym_encrypt()?
- [GENERAL] pgpool and foreign key on partitioned tables
- [GENERAL] pgpool II question
- [GENERAL] PgpoolAdmin installation
- [GENERAL] pgpoolAdmin:No such file or directory in /var/www/html/pgpoolAdmin-1.0.0/libs/Smarty.class.php on line 1258
- [GENERAL] Pgsql roles, SQL injection, and utility statements
- [GENERAL] Planning a Postgresql based Database
- [GENERAL] Please change default characterset for database cluster
- [GENERAL] Plpgsql function to join array elements with a string
- [GENERAL] plpgsql trigger original query
- [GENERAL] Poor performance with ON DELETE CASCADE
- [GENERAL] Porblems migrating a server.
- [GENERAL] postgres catalog files problem
- [GENERAL] Postgres Tamil Team
- [GENERAL] Postgresql 7.3 on Red Hat Enterprise 5 (Problem with SEMMNI, SEMMNS)
- [GENERAL] PostgreSQL and Crystal Report
- [GENERAL] Postgresql and SSL
- [GENERAL] PostgreSQL Conference Fall 07, all speaker slots filled!
- [GENERAL] PostgreSQL Glossary?
- [GENERAL] PostgreSQL with Kerberos and Active Directory
- [GENERAL] PQntuples return type
- [GENERAL] Preferred usage for 'copy to' for a subset of data
- [GENERAL] Preventing selection of data during transaction
- [GENERAL] Problem dropping table
- [GENERAL] problem with transactions in VB.NET using npgsql
- [GENERAL] problemas zona horaria
- [GENERAL] problemes pga_hba.conf
- [GENERAL] problems with large table
- [GENERAL] processing urls with tsearch2
- [GENERAL] psql connect_timeout feature
- [GENERAL] psql hanging
- [GENERAL] Q:Aggregrating Weekly Production Data. How do you do it?
- [GENERAL] query help
- [GENERAL] Query planner unaware of possibly best plan
- [GENERAL] Query with "like" is really slow
- [GENERAL] Querying database for table pk - better way?
- [GENERAL] Question about a query with two count fields
- [GENERAL] question about pg_dump -a
- [GENERAL] Question to schema public
- [GENERAL] queston about locking
- [GENERAL] Rankinf of Results?
- [GENERAL] read-only queries on PITRslaves, any progress?
- [GENERAL] Recall: August Monthly techdata split fi
|