lly interesting and uses
Graphviz. After doing the work to add the relationships I realised that
SchemaSpy does not like the oid system columns that we use for keys so
it wouldn't work. I will go ahead and replace them all with something
else and see how it does but I haven't gotten b
s to have a new lease of life at
schemaspy.org
Neil
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 9 Jun 2017 14:59, wrote:
Neil Anderson wrote:
> I've been exploring the pg_catalog tables and pointed a couple of tools at
> it to extract an ER diagram for a blog post. At first I thought it was a
bug
> in the drawing tool but it appears that the relationships between th
> The bigger picture here is that catalog changes are supposed to be
> executed by C code in response to DDL commands, and it's the C code
> that is charged with maintaining catalog consistency. Constraints
> would be useful if we supported updating the catalogs with direct
> SQL manipulations; bu
story as to why?
Thanks,
Neil
--
Neil Anderson
n...@postgrescompare.com
https://www.postgrescompare.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
>
> Thanks for the suggestion. Problem is the data is highly sensible and
> cannot go on the cloud or non trusted place
Sounds like the real question now is not how to import the data, but
how to convert the backups you have to CSV or similar?
Another idea for SQL Server is to use the bcp utility.
On 2 June 2017 at 11:57, stevenchang1213 wrote:
>
>
> tell me where this function add_job_history() is?
> Actually, I don't think you can count on ora2pg to transform your pl/sql
> code to plpgsql or other (un)trusted procedural language code. It's not that
> simple!
I wonder, does plpgsql compil
s is limited to 10GB on the later
versions. Another tool that can read SQL Server backups is SQL Data
Compare from Redgate, it has a 14 day trial.
http://www.red-gate.com/products/sql-development/sql-data-compare/
Neil Anderson
n...@postgrescompare.com
https://www.postgrescompare.com
--
Sent vi
LTIMES...
> ^
> NOTICE: relation "employees" does not exist, skipping
Since this is a NOTICE maybe it's a red herring? the results of a
CREATE IF NOT EXISTS or similar?
--
Neil Anderson
n...@postgrescompare.com
https://www.postgrescompare.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ttps://github.com/darold/ora2pg/blob/master/README#L307
> Hi Chris,
>
> I am able to get the output script in output.sql but now data migration is
> the big problem.
--
Neil Anderson
n...@postgrescompare.com
https://www.postgrescompare.com
--
Sent via pgsql-general maili
users (note: it is also possible to make users database
>> specific)
>> 4. list of defined databases
>
>
> And anything different below the above, I am thinking checking a dev cluster
> against a production cluster.
>
>
>
> --
> Adrian Klaver
> adrian.kla..
info.
>
>
>
> --
> *Melvin Davidson*
> I reserve the right to fantasize. Whether or not you
> wish to share my fantasy is entirely up to you.
>
--
Neil Anderson
n...@postgrescompare.com
https://www.postgrescompare.com
refer to
tighten it up.
I guess I don't know what is the most common way to say that it
compares everything but the data. Any suggestions from your
experience?
Thanks,
Neil
--
Neil Anderson
n...@postgrescompare.com
https://www.postgrescompare.com
--
Sent via pgsql-general mailin
>
> Feature freeze is in effect and we have a Beta release out. Major bugs or
> major usability issues are the only things that would cause any change to
> the catalogs at this point and there likely won't be many, if any, of those
> (at least not ones that necessitate catalog changes - must disco
cycle and whether or not I can
expect a lot of changes to the docs between now and release time for
v10?
Thanks
--
Neil Anderson
n...@postgrescompare.com
https://www.postgrescompare.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
nge naming convention. It has a whiff of Visual Basic Type
Characters about it,
https://docs.microsoft.com/en-us/dotnet/articles/visual-basic/programming-guide/language-features/data-types/type-characters.
Any chance there is a connection there?
--
Neil Anderson
n...@postgrescompare.com
http
y)
WHERE tables.relname = 'films' AND columns.attnum > 0;
Thanks,
Neil
--
Neil Anderson
n...@postgrescompare.com
https://www.postgrescompare.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 9 May 2017 at 06:20, Neil Anderson wrote:
> On 9 May 2017 at 05:26, Francisco Olarte wrote:
>> Paul:
>>
>> On Tue, May 9, 2017 at 2:45 AM, Paul Hughes wrote:
>>> My question still remains though - why is it that all the largest web
>>> platforms
On 9 May 2017 at 05:26, Francisco Olarte wrote:
> Paul:
>
> On Tue, May 9, 2017 at 2:45 AM, Paul Hughes wrote:
>> My question still remains though - why is it that all the largest web
>> platforms that have used PostgreSQL *specifically* choose Python as their
>> back-end language?
>
> Do y
content=webmail&utm_term=icon>
>> Virus-free. www.avast.com
>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link>
>>
>> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
>
>
stick with one or the other. In the early
days while you have little data to worry about you might use the static
approach and then switch to migrations. You just pick a baseline to
start from and carry on from there.
--
Neil Anderson
n...@postgrescompare.com
http://blog.postgrescompare.com
-
stick with one or the other. In the early
days while you have little data to worry about you might use the static
approach and then switch to migrations. You just pick a baseline to
start from and carry on from there.
--
Neil Anderson
n...@postgrescompare.com
http://blog.postgrescompare.com
-
grationToolkit.java:3376)
at com.edb.MigrationToolkit.main(MigrationToolkit.java:1700)
Caused by: java.lang.ClassNotFoundException: org.postgresql.Driver
On Thu, Jun 16, 2016 at 8:59 PM, Neil Anderson
mailto:neil.t.ander...@gmail.com>> wrote:
On 2016-06-16 11:13 AM, Durgamahesh Manne wrote:
essing here but
having quickly looked at the documentation have you tried specifying the
'-targetdbtype postgres' in addition to the '-sourcedbtype sqlserver'
that you have already specified?
Neil A
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> On Jan 24, 2016, at 7:59 PM, Roxanne Reid-Bennett wrote:
>
>> On 1/23/2016 3:31 PM, Joshua D. Drake wrote:
>>> On 01/23/2016 03:08 PM, Adrian Klaver wrote:
On 01/23/2016 03:03 PM, Berend Tober wrote:
Adrian Klaver wrote:
> Motion:
>
> The Coc discussion be moved to its
rticipants
should be tolerant of people’s right to have opposing views and always assume
good intentions.
Neil
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
g rather than dismissive.
>
How about a simple statement?
2. We expect people to be both tolerant and respectful of others.
Neil
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e stated that everyone is expected to be tolerant of
others. A free society cannot exist without some level of tolerance.
Neil
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ss does not degrade value except at
the extreme. Often someone that is ‘rough around the edges’ has to be better
at their work to make up for it. These are good people to keep around if
possible.
Neil
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ys have used the current definitions not the original
and those can be exported with the current names.
It just seems like busy work to me, but I would love to be enlightened.
Neil
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
h
ations so maybe someone should chime
in if this is a bad best practice.
Neil
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
as
an earlier intellectual exercise.
Most people would just use general rules of thumb or their experience to create
indexes until specific performance indicated something else is needed. Then
they would solve the specific performance issue.
Neil
> On Feb 26, 2015, at 8:14 AM, Sreerama Ma
es and indexes and get
your application up and running. When you start noticing slowdowns, track them
down and only make adjustments to the db when you are solving a real problem.
Neil
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
guaranteed to
exist.
Also posted on stackoverflow:
http://stackoverflow.com/questions/26691725/postgresql-9-4-expand-jsonb-int-array-into-table-with-row-numbers
Thanks,
Neil
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
On Sep 22, 2014, at 9:46 AM, Paul Jungwirth
wrote:
>>> Can you confirm that your software is SHA-256 Compliant?
>
> Postgres's SSL certificate & key live at the value of ssl_cert_file
> and ssl_key_file in your postgresql.conf. Why not point it at a
> SHA-256 certificate, restart, and try it ou
On Feb 6, 2014, at 12:44 PM, Scott Marlowe wrote:
> Merlin, this reminds me of the quote from Mencken: For every complex
> problem there is an answer that is clear, simple, and wrong.
Or as Niklaus Wirth said.
... complexity has and will maintain a strong fascination for many people. It
is t
Note the number of exclusive locks in my first message, it is equal to the
number of threads (20). Also, the ALTER was not running then, apologies if
that was not clear.
On Wednesday, January 29, 2014, Thomas Kellerer wrote:
> Neil Harkins wrote on 29.01.2014 23:37:
>
>> I totall
I totally understand DDL taking exclusive locks, the problem here seems to
be that the *SELECTs* are taking out exclusive locks, locking out the
ALTER, which feels like a bug.
On Wednesday, January 29, 2014, Peter Eisentraut wrote:
> On 1/29/14, 4:59 PM, Neil Harkins wrote:
> > Why
20
AccessShareLock | 440
(2 rows)
Why are those exclusive locks present?
Can't the database rely on mvcc for those reads
without locking? The autocommit should be
increasing the xid used for the reads, so the
ALTER should be able to slip in-between?
thanks in advance for any input,
-n
ze that all
the code should go exclusively into the database or the app.
Neil
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
uld I use the --xlog parameter and if so do I need to change
wal_keep_segments from 0?
Thanks!
Neil
ormance. This will take a little work on
your part, but that is how you learn.
Neil
Yes, it does indeed interleave and it seems to archive the backlog just
before the files are about to be deleted. That explains it.
Thanks for your help,
Neil
2013/1/31 Jeff Janes
> On Thu, Jan 31, 2013 at 12:50 AM, Neil Worden
> wrote:
> >
> > The situation is as fo
hich
i do not understand. All this started exactly 3 minutes after i set the
archive_command and enabled archiving.
Is this normal behaviour, or am i getting something fundamentally wrong ?
Thanks, Neil
ps.: These things cast aside, i still do not understand how to implement
the "One base
process last was 0001008E0058
postgres 11504 0.0 0.0 20816 1412 ?Ss Jan29 0:54 postgres:
stats collector process
Am i missing something ?
Thanks, Neil
2013/1/31 Neil Worden
>
> Btw, ps shows:
>
> postgres@darkblue:/data/pgdata/pg_xlog$ ps aux | grep pos
Any ideas ?
Thanks, Neil.
2013/1/31 Neil Worden
> >>> If your command does overwrite, then the server currently emitting the
> >>> 8D files will become unrecoverable once those files start getting
> >>> overwritten. If it refuses to overwrite, but returns
chive-command is responsible for not overwriting
wal-files. But if that situation occurs, and if i understand you correctly
it will, what do i do ?
If the wal-archive files will be overwritten at some point in time, how is
it possible to only have one single base-backup at time-point t and from
then on only store the following wal-files ( however inconvenient that may
be ) to be able to restore to any point in time after time t ?
Thanks,
Neil
n and using a proper archive_command ?
I have spent a more than a few hours on this, but am currently somewhat
lost.
Thanks in advance,
Neil
On Jan 9, 2012, at 5:07 AM, Alban Hertroys wrote:
> On 9 January 2012 09:56, Damiano ALBANI
>>> I believe DB2 is pretty much it in this area.
>>
>> For the record, it looks like MS SQL Server has some equivalent feature :
>> FILESTREAM.
>
> And Oracle has BFILE.
>
> I've actually been thinking
y is the postmaster in
> /usr/bin when your psql is in /opt/local/lib/postgresql90?) ... but
> frankly, I cannot imagine a sane reason for setting
> unix_socket_directory with that mechanism, unless you're intentionally
> trying to make it hard to connect. (And those unix_socket
On Sep 24, 2011, at 4:21 PM, Guillaume Lelarge wrote:
> On Sat, 2011-09-24 at 14:43 -0500, Neil Tiffin wrote:
>> On Sep 24, 2011, at 1:31 PM, Joe Conway wrote:
>>
>>> On 09/23/2011 02:33 PM, Neil Tiffin wrote:
>>>> I have shared_buffers in the config file se
On Sep 24, 2011, at 1:31 PM, Joe Conway wrote:
> On 09/23/2011 02:33 PM, Neil Tiffin wrote:
>> I have shared_buffers in the config file set for 32 MB and pgAdmin
>> reports a value of 32 MB, but pgAdmin also says the current value is
>> 4096. Can anyone point me to a
me to any docs about why the current value may be different than the
config value? Temp_buffers are the same way, config file 8MB, but current
value in pgAdmin is 1024?
Thank you.
Neil
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
--docroot . &
Point your browser to http://192.168.1.1:8081/
<http://192.168.1.1:8080/>and browse - this should be your nic address
, otherwise you can always use
127.0.0.1
Default logins and passwords are as given in my previous mail.
Any difficulties, please email me - i tried all the steps mentioned here -
but something could have gone wrong.
Kind Regards,
Neil
7
8 | abhishekc | abhishekc123 | 8
If it crashes - please mail me and I will restart it.
Kind Regards,
Neil
On Mon, Dec 20, 2010 at 8:39 PM, Carlos Mennens wrote:
> I'm just wondering what programs you guys / girls are using PostgreSQL
> for. So fa
quot; directory has 2 sample input scripts which demonstrate
the modified sql grammar - but the project is far from complete.
Kind regards,
Neil Xavier D'Souza
On Sat, Oct 23, 2010 at 1:59 AM, Andre Lopes wrote:
> Hi,
>
> I need to do some repetitive work in form creation to ins
| almonds | 7
8 | nuts| hazelnuts | 8
9 | nuts| pine-seeds | 9
(9 rows)
Many Thanks once again,
Kind Regards,
Neil
>> --
>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>
| banana | 2
3 | fruit | apple | 3
4 | vegetable | cabbage | 4
5 | vegetable | cauliflower | 5
6 | vegetable | okra | 6
7 | nuts | almonds | 7
8 | nuts | hazelnuts
Hello,
I have a dilema and I was hoping someone here may offer guidance or assistance.
I bet this is a very simple question for someone out there but I am having
problems coming up with a solution. Here it is...
suppose I have a field with the following values:
77.1
77.2
134.1
134.2
134.3
5.1
ne show me how to use a JOIN with the above SQL Statement? I need to
bring the customername field into the query from the other table and I have
been having issues writting the query... can this even be done?
Thanks,
Neil
king for from one SELECT statement using the data
example from above:
count1 | count2 | count3
---
2 2 4
Can this be done with ONE SQL STATEMENT? touching the database only ONE time?
Please let me know.
Thanx> :)
NEiL
count for the WHERE criteria with the
filter criteria tagged on, or is there some clever trick that I'm not aware
of? I'd rather not count in the application as I'd like to plan for the day
we have up to 100k properties (
Any suggestions gratefully received!
Ta,
Neil.
Tom Lane-2 wrote:
>
> Sorry, I meant to ask whether the *failure* was repeatable.
>
Oh, I see. Well, to the extent that i had the same problem in two different
remote clients before finding that the local connection work-around made it
go away, I would say that it was repeatable. In short,
Tom Lane-2 wrote:
>
> Neil Best writes:
>> On Fri, Aug 7, 2009 at 12:33 PM, Tom Lane wrote:
>>> BTW, the "SSL renegotiation failure" bit
>>> suggests that it could have been an OpenSSL bug not a real network
>>> lossage, so you might want to
Tom Lane-2 wrote:
>
> Neil Best writes:
>> On Fri, Aug 7, 2009 at 12:33 PM, Tom Lane wrote:
>>> BTW, the "SSL renegotiation failure" bit
>>> suggests that it could have been an OpenSSL bug not a real network
>>> lossage, so you might want to
On Fri, Aug 7, 2009 at 12:33 PM, Tom Lane wrote:
> BTW, the "SSL renegotiation failure" bit
> suggests that it could have been an OpenSSL bug not a real network
> lossage, so you might want to see how up-to-date your openssl libraries
> are.
Thanks for your comments, Tom. The operation seems more
Tom Lane-2 wrote:
>
> Hmm. It looks like psql could get into an infinite loop if the server
> failed to exit COPY IN mode for some reason, but it's not at all clear
> how that could happen (or what to do about it). What server version
> and what psql version is this? What does the server's l
doing what I could to minimize that
possibility had no effect. Maybe I need to use separate connections?
The only reference I could find to that error message was
http://doxygen.postgresql.org/bin_2psql_2copy_8h.html but I know absolutely
nil about the source code.
Thanks.
Neil
--
View
Oracle compatibility, so I'd
imagine they support this syntax, although their online documentation
doesn't mention it -- www.enterprisedb.com
-Neil
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
trigger the problem and the
relevant schema definitions.
-Neil
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
has a README
with some additional information. Personally I find the hash index code
easiest to understand, although it has the fewest features.
-Neil
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your des
ialects", similar to "--std=..." in GCC or SQL modes in MySQL 5. That
would help people who want to write standard-compliant applications
while not inconveniencing those who don't care.
-Neil
---(end of broadcast)---
TIP
then construct and return the normal pg_locks result set.
-Neil
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
I don't see the point --
why would an application want to use the API? SQL is much more flexible.
-Neil
---(end of broadcast)---
TIP 6: explain analyze is your friend
ssion:
http://archives.postgresql.org/pgsql-hackers/2006-02/msg00465.php
-Neil
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
ipt to generate a
sql statement in a temporary file (e.g. /tmp/setbackupdate.sql) then use
psql to then update a record in your database with a command like (psql
-c /tmp/setbackupdate.sql)
Regards Neil.
Doug McNaught wrote:
Richard Sydney-Smith <[EMAIL PROTECTED]> writes:
On Fri, 2006-01-20 at 09:16 +0100, DB Subscriptions wrote:
> BEGIN
> CREATE USER NEW.userid WITH PASSWORD NEW.pword IN GROUP NEW.groupe;
>
> RETURN new;
> END;
You can't use PL/PgSQL variables in DDL commands. Try using EXECUTE:
EXECUTE 'CREATE USER '
Thanks for the help, Tom, and others who made suggestions.
I compiled and installed 8.0.6 with no problems on OS X 10.2.8
My little old imac's a happy postgres host now.
Neil
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> Neil Brandt <[EMAIL PROTECTED]> writes:
&
ld be applicable.
> Maybe an easier question is, can we expect a TOAST performance increase
> when upgrading to 8.1?
A lot of performance improvements have been made since since 7.4, but I
don't believe any of them have affected TOAST in particular.
-Neil
-
[storage-recursive] Error 2
make[1]: *** [all] Error 2
make: *** [all] Error 2
Searching, I couldn't find anything useful on the F_FULLFSYNC constant, and no
reports on a
similar failure.
Any ideas? (Help!)
Thanks,
Neil
__
ill be less noticeable.
Since an INSERT ... VALUES without a subselect or any applicable rules
requires very little parsing, planning, or rewriting time,
PREPARE/EXECUTE is unlikely to improve performance.
-Neil
[1] http://developer.postgresql.org/docs/postgres/sql-prepare.html
---
ime a function is
invoked in a given session, so there is probably no (performance) reason
to do it by hand.
-Neil
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
, not a problem with
PostgreSQL itself.
-Neil
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the
ever, the Slony II project
is based on the same theoretical foundation (Kemme's Postgres-R work),
and is under active development. The website is http://www.slony2.org;
Gavin's talk is worth reading. We should have more information on the
details of the design ava
0709.php
should work. But I agree with the other folks in this thread who have
questioned whether this is a good idea: backend APIs are known to change
significantly between releases, and making assumptions about how they
behave seems like asking for trouble to me.
-Neil
--
which could then do the sort in parallel. Postgres currently doesn't do
this, but it doesn't have much to do with threads vs. processes per se
(threads might make this somewhat easier to implement, though).
-Neil
---(end of broadcast)---
TIP
umber" (on-disk position of the column) as well as a "logical column
numer" (position of the column in the table -- e.g. in SELECT *
expansion) would also make it easy to implement column reordering in
ALTER TABLE, which has been requested a few times.
-Neil
--
han nothing:
http://neilc.treehou.se/optimizer.pdf
http://conferences.oreillynet.com/presentations/os2003/lane_tom.pdf
-Neil
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if y
find any documentation on this. What's the best
> prectice for this situation?
You can use a signed type with a CHECK constraint to restrict the
column's value to positive integers.
-Neil
---(end of broadcast)---
TIP 3: Have you chec
On Thursday 06 October 2005 08:34, Jim C. Nasby wrote:
> On Wed, Oct 05, 2005 at 04:14:03PM -0400, Andrew Sullivan wrote:
> > On Wed, Oct 05, 2005 at 09:49:06PM +1000, Neil Dugan wrote:
> > > If I was to develop a 'C' project that only used the libpg.so library
> &g
p
(I think Bugzilla is *completely* the wrong tool for the Postgres
development model.)
I've heard vague comments from Debian people that the debbugs code is
kind of evil, although I haven't confirmed that myself. Writing a system
like this from scratch would n
known issue -- see the -hackers archives
for many prior discussions. MVCC makes this hard to solve effectively
(whether applications should actually be using COUNT(*) on large tables
with no WHERE clause is another matter...)
-Neil
---(end of broadcast)
> >
> > _and_ you need to preserve the copyright notices.
>
> excellent point.
>
If I was to develop a 'C' project that only used the libpg.so library and the
rest was my own stuff would I need to preserve the copyright to somehow?
I wouldn't be distrib
RPM packages you can install depending on if you just want
to access a databases (on another computer) or also setup the server to
create/access a database on your computer.
To install posgresql version 8.0.3
# yum install postgresql
# yum install postgresql-server
Regards Neil
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
er they get back to
base to run a script and update the master according to any change
since the last time (according to the date).
Regards Neil
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
sub
neilc=# select octet_length(x) from t2;
octet_length
--
0
(1 row)
Put it another way, will char '' be saved as char(1) or char '' does not
use space at all?
I'm not sure what you mean.
-Neil
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Kevin Murphy wrote:
I just wanted to confirm that the COPY command always stores data in the
table in the order in which it appears in the import file.
This is not the case -- depending on the content of the FSM, the newly
added rows might be distributed throughout the table.
-Neil
Alvaro Herrera wrote:
IIRC Neil Conway posted a patch to make 8.0.2 use LRU instead of ARC,
when the whole patent issue arised.
http://archives.postgresql.org/pgsql-patches/2005-01/msg00253.php
-Neil
---(end of broadcast)---
TIP 9: In versions
.
Well, data loss is certainly possible. Suppose a power failure caused
the machine to go down and (for whatever reason) also resulted in losing
the disk on which the WAL is stored. Since recovery will not be
possible, there will probably be data corruption.
-Neil
---(end
[EMAIL PROTECTED] wrote:
Does Postgres have any kind of configuration that determines the
speed of data transfer to the clients?
No.
Is there any kind of connection priority?
No, although it is possible to crudely set priorities via OS-level tools
like nice(1).
-Neil
1 - 100 of 247 matches
Mail list logo
