uld be used to do an update.
this updated fork, https://github.com/CartoDB/odbc_fdw runs on newer
postgres, but also is based on a select statement, you can't UPDATE a
resultset...
--
john r pierce, recycling bits in santa cruz
ats totally
configurable with commandline parameters, from a few dozen kilobytes to
many gigabytes.
--
john r pierce, recycling bits in santa cruz
ll
input time values to UTC, and store it in an internal representation,
and on output, they are converted to the client's current TIMEZONE.
--
john r pierce, recycling bits in santa cruz
package, and includes/depends on
postgresdql-libs which are the runtime libaries.
--
john r pierce, recycling bits in santa cruz
On 12/9/2017 5:46 PM, Stefan Keller wrote:
Below I re-modeled it to a relational schema as you suggested and also
tried to utilize the INHERITS feature.
Does that look better?
I believe I would use boolean, not bit.
--
john r pierce, recycling bits in santa cruz
.
--
john r pierce, recycling bits in santa cruz
iness logic
in appserver modules outside the database and only used plpgsql for
things where performance mattered significantly.
the more heavily your apps use Oracle specific features, the more work
the conversion will be.
--
john r pierce, recycling bits in santa cruz
olume to /var/lib/pgsql before I initialize the
database. reason I do the pgsql dir and not the version specific data
directory is so pg_upgrade can use link mode to upgrade a cluster.
--
john r pierce, recycling bits in santa cruz
On 12/6/2017 11:33 AM, Andres Freund wrote:
PostgreSQL 10 does indeed have a parallel query feature that will use
multiple cores. you have to explicity invoke it.
"you have to explicitly invoke it" - huh?
oops, I meant, enable.
--
john r pierce, recycling bits in santa cruz
as to the sorts of queries that can
be parallized, but this will be enhanced in future versions.
https://www.postgresql.org/docs/current/static/parallel-query.html (read
the whole chapter)
--
john r pierce, recycling bits in santa cruz
. restores have to create indexes.
creating indexes on multi-million-row tables can take awhile. (hint, be
sure to set maintenance_work_mem to 1GB before doing this!)
--
john r pierce, recycling bits in santa cruz
that:
on SELECT RULEs
VIEWs
column GRANTs
RLS
yeah, but its so much cooler if you invent a bunch of proprietary
methods of doing the same thing, and give it new marketing buzzwords !!!
--
john r pierce, recycling bits in santa cruz
On 12/4/2017 2:21 PM, chris kim wrote:
How would I investigate if my database is nearing a transaction wrap
around.
it would be screaming bloody murder in the log, for one.
--
john r pierce, recycling bits in santa cruz
?
how many rows does 'blah' match ?
what is...
SELECT pg_column_size(json_array_elements(json_rmq -> 'orders'::text))
FROM table_name
WHERE blah;
?
--
john r pierce, recycling bits in santa cruz
On 12/3/2017 3:18 PM, Yuri Budilov wrote:
Posted on Stack Overflow, sadly no replies, so trying here
...
,,,
why did you email me personally ?
--
john r pierce, recycling bits in santa cruz
x27;ve put pieces in
place to mitigate that issue.
a single connection will only ever use more than one core if its
explicitly doing concurrent query.
--
john r pierce, recycling bits in santa cruz
server not an advocacy for more cores.
well, if you have significant concurrency with high CPU usage, you want
both more AND faster cores
--
john r pierce, recycling bits in santa cruz
will take quite a bit
of space
--
john r pierce, recycling bits in santa cruz
On 11/26/2017 8:10 PM, chandra sekhar wrote:
What is the query to get list of the archive log files to capture
start date and time of each archive log
ls -l nfsserver:/path/to/archive
--
john r pierce, recycling bits in santa cruz
tatic/user-manag.html
https://www.postgresql.org/docs/current/static/sql-grant.html
https://www.postgresql.org/docs/current/static/sql-revoke.html
https://www.postgresql.org/docs/current/static/sql-alterdefaultprivileges.html
--
john r pierce, recycling bits in santa cruz
the server will flush all the hardware caches
AND the OS cache.
--
john r pierce, recycling bits in santa cruz
On 11/21/2017 11:42 AM, Joshua D. Drake wrote:
I am not sure if that is sarcasm but I think the reason is pretty self
explanatory. -Hackers have all the people that understand how all this
works, -general has all the people that don't.
rotfl, and ain't that the truth.
--
joh
noticed it.
--
john r pierce, recycling bits in santa cruz
P any DKIM out of the original messages, and
continue to munge headers and footers like mail list reflectors have
been doing for decades.
--
john r pierce, recycling bits in santa cruz
u next to the 'Reply'
button.
--
john r pierce, recycling bits in santa cruz
essage, and find the List-Unsubscribe: header, copy/paste that link to
your browser, and voila, away you go.
--
john r pierce, recycling bits in santa cruz
On 11/20/2017 12:49 PM, John R Pierce wrote:
Sigh, not surprised about gmail, its amazing how many .com's and
.org's use it now. I'm not at ALL a fan of how the web client handles
a bunch of stuff like replies, & hiding your own messages from yourself.
oh and my biggest
on my monitor.
Sigh, not surprised about gmail, its amazing how many .com's and .org's
use it now. I'm not at ALL a fan of how the web client handles a bunch
of stuff like replies, & hiding your own messages from yourself. I
mostly prefer to use gmail as an imap server w/
ve to copy/paste them to a
browser.
--
john r pierce, recycling bits in santa cruz
thats a feature of many email list SERVERS, not the email clients.
Mailman in particular looks for the major command keywords in the first
few lines of the email, and will respond to them, even if they are sent
to the regular list address instead of the command address.
--
john r pierce, recy
majority of users never see the full headers, they just see From,
To, Date, Subject, and everything else is hidden. on a phone or a web
mail system like gmail, its very hard to see that stuff.
--
john r pierce, recycling bits in santa cruz
where I want it.
I realize why this was done, and yada yada, what a mess.
--
john r pierce, recycling bits in santa cruz
32 matches
Mail list logo
